Hello Again,
Referring to the link HERE . Can someone help me please.
Referring to the link HERE . Can someone help me please.
Code:
I am looking for VBA macros to compare 2 worksheets within same workbook. I am always receiving more than 10,000 to 50,000 member’s data on daily basis.
Compare worksheet (Quote List) with worksheet (Policy Issuance List) based on ID number in column H. if difference found then copy entire row to worksheet (Discrepancy Records) and highlight cell value which is changed.
For Example:
In worksheet (Quote List) look for ID number “2099421261” i.e. row no. 1 in worksheet (Policy Issuance List) i.e. row no. 3 and found difference in age. So, copy the entire row to worksheet (Discrepancy Records) and highlight cell value E2 in worksheet (Discrepancy Records).
I hope that above details are sufficient to understand my problem.
Copy of a sample worksheet is attached for your reference.