Hello all,
I have a spreadsheet that was given to me with 23 tabs, each tab has four columns (Hub, Address, City, Zip). What I have been asked to do is create a new tab within this spreadsheet that combines all the information from the 23 tabs, removes duplicate address's and gives me the number of times each address had been delivered to. Is there a way to accomplish this?
I have been trying to use VLOOKUP but not having much luck right now.
Any one have any suggestions?
Thanks,
Hi and welcome to the forum
I know this is tedious, but maybe just copy all 23 sheets, 1 below the other, onto a new sheet, and then use "remove" duplicates"?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks