Match the duplicates and copy only selected column data

**Yogi28** · 08-30-2012, 05:08 AM

Hi there,

I have found many scripts that copy the data from one to another but I need help with my files.
I have provided complete description in the Excel file itself.

However I am writing it here for reference:
I have 2 Excel files: 1 is "MasterMaster File with over 2 lakh of data_sample"
2 is "Update Data from master"

Both the files have same type of columns but file 2 does not have some columns same as master file.I want to update the second file and get the data from Master.

Master File with over 2 lakh of data_sample.xlsx
Update Data from master.xlsx

Thanks,
Yogi

**patel45** · 08-30-2012, 06:07 AM

use this macro on Update Data from master, the 2 wb must be in the same directory, master wb not open

Please Login or Register  to view this content.

**watersev** · 08-30-2012, 08:36 AM

hi Yogi28, different VB approach, please check attachment, save both files to the same folder, open Update_Data_from_master(1).xlsm and press "Update" button

**patel45** · 08-30-2012, 09:01 AM

watersev I think is better

Please Login or Register  to view this content.

**Yogi28** · 08-30-2012, 01:03 PM

Downloaded the 2 new files. When I click the update button it gives runtime error. I think file name changed due to some missing font. Is that the case?