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
Individual sheet
once you run the code
master sheet should become
Please guide me to make this VBA code.
Thanks in advance
Example
Master sheet
A | B | C | D | E |
Data 1 | 10 | |||
Data 2 | 15 |
Individual sheet
A | B | C | D | E |
Data 1 | 10 | a | b | c |
Data 3 | 20 |
once you run the code
master sheet should become
A | B | C | D | E |
Data 1 | 10 | a | b | c |
Data 2 | 15 |
Please guide me to make this VBA code.
Thanks in advance