We have a couple of sheets with data.
Each with about 100 rows of data, containing various information, spread out over 57 columns.
I have been updating this sheet with information but now the powers that be are starting to send updated versions of the document out.
These newer versions may contain new entries or some removed. My issues is merging this data together.
Currently, I have to open both spreadsheets and manually go down each row and see what is new and what has been removed. It is tedious to say the least.
Is there a trick, a way, to merge this information in such as a way as:
If the newer spreadsheet has extra entries that don't appear on the original, add the row.
If the newer spreadsheet is missing a row from the original, delete that row from the original.
All this can be based off the first column if required since that contains the name and never will be modified, it is a good achor point.
I would rather avoid using VBA, but if required I can, I would run it from another spreadsheet as I don't want to make our master sheet a macro enabled workbook, for various reasons.
Can anything be done to help?
Bookmarks