Vba code to update the master excel sheet based on matching two columns of individual

karthikumar

New member
Joined
May 7, 2015
Messages
1
Reaction score
0
Points
0
I have to update the master excel sheet which has more than 80, 000 rows based on the individual sheets. The VBA code should help me to check the data present in A and B columns of both master sheet and individual sheets. If it matches, vba code should copy the remaining rows (C to M) from individual sheet and paste it in exactly the matched data of master sheet.

Example

Master sheet
ABCDE
Data 110
Data 215

Individual sheet



ABCDE
Data 110abc
Data 320


once you run the code


master sheet should become


ABCDE
Data 110abc
Data 215



Please guide me to make this VBA code.

Thanks in advance
 
Back
Top