Hi! I'm trying to create a macro that updates a list of items purchased - I want it to reference a source file which will have duplicate items in it. So say I bought the following fruits:
- Apples
Banana
Orange
Apple
Berries
Banana
Mango
I have a summary list that includes apples, bananas and oranges. How do I update this list using a macro?(Is that even possible??) I want it to look at the source file and remove duplicate values and check to see is there are any new values and add them to the summary list.
Bookmarks