I would like my sheet to check on sheet 2 any doc# (column C) thats not already listed on sheet 1 and copy and paste as values the missing doc# into sheet 1 as well as all columns that match (from colum c to p on sheet 1)
the reason I am not just using an index match is because my sheet 2 is an external source that keeps changing data and past data gets erased when the new one is imported
attaching example sheet.
Bookmarks