mchilapur
07-02-2014, 08:11 PM
Dear all,
I have two sheets in same excel work book.
Sheet1 has some 5000 rows with new data range from 'A:A to AZ:AZ'.
Same is the case with Sheet2 but 7000 rows of old data.
Few data between both the sheets is common and few data in sheet1 is brand new.
I need a VBA code to compare sheet2 with sheet1 and copy the difference of data from sheet1 to sheet2.
In short, sheet2 must have old data along with new data from sheet1.
I know the range to compare is too high, but plz help me with a fast working code.
PS:I cannot copy entire sheet1 to sheet2 due to some constrains.
Thanks all.
I have two sheets in same excel work book.
Sheet1 has some 5000 rows with new data range from 'A:A to AZ:AZ'.
Same is the case with Sheet2 but 7000 rows of old data.
Few data between both the sheets is common and few data in sheet1 is brand new.
I need a VBA code to compare sheet2 with sheet1 and copy the difference of data from sheet1 to sheet2.
In short, sheet2 must have old data along with new data from sheet1.
I know the range to compare is too high, but plz help me with a fast working code.
PS:I cannot copy entire sheet1 to sheet2 due to some constrains.
Thanks all.