Worksheet 1 is the item master file and it has item numbers in column a. Worksheet 2 is a transaction file which has matching item numbers in column c (they match worksheet 1) but also might have new item numbers. Is there a function which I can use which would find the new item numbers on worksheet 2 and add them to worksheet 1?
Thanks
Bookmarks