Copying records from one workbook to another if new data

[PDW5000]

Hi all,

Sorry for my first post to be asking for help. I don't have any experience with macros, but I'm trying to create one which will allow me to copy rows from one workbook to another based on whether a row with a unique ID already exists in the destination file.

I have two files, a master file called "master transfer file.xls" and then will get report files called "new data.xls." Both files have the same columns (but the master file has some additional manually entered columns at the far right. The new data files will have some records that are already in the master file and I want to ignore those (if column E in the row in the new data file equals any row column E in the master file. If the the value for column E doesn't already exist in the master file, I want to copy that row.

Can anyone provide a suggestion or point me in the right direction?

Thanks!

[ravishankar]

HI
Why don't you simply save master transfer file.xls as "new data.xls". If you there is no difference between the two.
Ravi

[excelxx]

Hi PDW500

The following code if copied to the master transfer file, may meet your requirements.

You will need to change the worksheet references in the code to refer to your actual worksheets.

Please Login or Register  to view this content.