Goal-
Make the two lists match while preserving comments on 'Updated'
Given:
Sheet 'Data' contains an updated list of items and associated data
Sheet 'Updated' contains previous list of data which may or may not match 'Data'
Each Product has a unique identifier (ex Item 1) to use for look up.
Example: Item 1 is on 'Data' but not on 'Updated'
If Item exists on 'Data', but not on 'Updated', Copy A1:I1 to 'Updated' to next open cell on column A:I.
If Item exists on 'Updated' but not on 'Data', Delete entire row
Thanks in advance!
Bookmarks