Hi guys,
I have 2 spreadsheets that need to be combined into 1. However, the spreadsheets may contain duplicate names. I need a macro that will grab only 1 of each user and put it on a sheet3. The ID will always be unique for this (Column C). See attached. Sheet 1 and Sheet 2 are my users, and Sheet 3 is what I would like the macro to generate.
Thanks for the help!
Last edited by TShelt; 12-01-2011 at 11:47 AM.
Try this
Please Login or Register to view this content.
Nice. There's just slight error when you run this macro twice (it put header row below)
Chip provides http://www.cpearson.com/excel/MergeListsToDistinct.aspx
Why run it twice?
IF run it twice
I don't know why.. Not my case
Maybe you've uploaded first or second sheet and now you want to refresh third one again.
I've just notice that.. If user say it's fine by him, then fine by me too.
@zbor
True, why ask questions
Please Login or Register to view this content.
Not sure why its not working for me. That is just copying both lists to sheet3, not removing duplicates.
Nvm. It appeared that one of my lists that is fed to me has a space before the IDs.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks