This issue almost fits this box: https://www.excelforum.com/tips-and-...zing-data.html.
I could not handle two headers so I removed the product code from the Original and saved the information on the Lookups sheet. This can be restored in the normal result with a VLookup.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks