Friends,
I am new to VBA. I need a help in the following :
I have 2 spreadsheets :
A) Workbook A :
C1, C2, C3, C4, C5
R1
R2
R3
R4
R5
B) Workbook B
C1, C3, C5
R1
R2
R3
Note the following :
1. Workbook A has more columns and rows (new rows).
2. Both workbooks will have data
My Requirement:
I want to update Workbook B with following requirements:
1) Look for all existing rows and columns of Workbook B in Workbook A
and then update Workbook B with latest values for those already
existing and then add new rows with only required columns (C1, C3 & C5)
of new rows.
2) I also would like to capture the changes made to existing rows.
As this is a routine job for me, I would like to write a VBA code to save time.
My advance thanks to those who will help me on this.
Bookmarks