LinkBack URL
About LinkBacks
Merging Two Worksheets..with a twist
Hello!
I am a real noob at this, and it sound simple logically, but I need help with doing it in Excel.
We have spreadsheets that are set up in an arbitrary order for a purpose, and a new employee sorted them alphabetically. Now we have no way of putting them back to how they originally were...
Except, we have old files from a backup a while ago. Prices, new descriptions, and new products have been added since then. There is a column with unique model numbers (although they do include letters, too) that, if we lined up the rows from the new spreadsheet (that is alphabetically sorted) with the old spreadsheet (that is correctly arbitrarily sorted), we would be back in business without needing to figure out the new prices, descriptions and new products, or to go back through and reorder them manually.
In the example provided, "Alphabetically Wrongly Sorted," the first column is what got sorted alphabetically. The second column has the unique model numbers. The third and fourth row represent prices and descriptions, and there is also several columns we have added recently (represented by the last column with numbers in it), and several more rows that we have added (represented by zed). "Arbitrarily Correctly Sorted" represents the old (and correctly sorted) files, with fewer columns and rows, but it still has the second column with many of the same unique model numbers.
The "Correctly Merged" spreadsheet would line up all of the information from the "Alphabetically Wrongly Sorted" spreadsheet with the arbitrarily sorted unique model numbers from the "Arbitrarily Correctly Sorted" spreadsheet. All the new rows could just be left at the end.
How would I go about doing this? I would really appreciate the help!
Register To Reply
Bookmarks