I have a master spreadsheet with names and email address on it. Every week i get a new spreadsheet which contains all the information from the master basically but with additional names added in. Is there a way to put the new spreadsheet in to the master without the duplicates coming with it? Sorting and then deleting the duplicates is becoming too time consuming as the list grows.
You can have a macro that does everything for you - appending & deleting.
Do you have a sample file that you can attach?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks