Hello
I have a workbook in which a specific working sheet with specific columns needs to be copied to a closed master workbook .
Columns F(reference id) to I, then K, then AH are to copied to the closed databaserecord workbook on sheet master 2017
Row 1 are headers for each workbook.
However one criteria is needed are that column F(reference id ) of workings sheets must be unique in copying to columms A (reference id) of closed workbook.
that is if say reference id in workings sheets is 17067729 ( columns F ), if that reference exists in database records then it should not be copied together with requested specific columns
But if reference id columns F (17067729) does not not exists in data base records column A then copy Columns F(reference id) to I, then K, then AH are to copied to database records .
the database recordscworkbook have the path c:\\dabase 2017
However when finishing copy, can a message box appear specify the no of unique records copied to master work and no of duplicates not copied
Can anyone help for a vba code .
the workings book are about rows 6000 rows of data, sometimes it may have 2000 rows or 3500 rows
Bookmarks