Ok, so I have been looking for a clean and clear solution to this all morning and can't find one. I would like to compare two lists on different worksheets (sheets 1 & 2, column C) and create a new list (Sheet 3, column A) that will update with worksheet changes to combine the two lists and not include duplicates.
Sheet 1
Column C
Apple
Oranges
Bananas
Sheet 2
Column C
Apple
Banana
Peach
Sheet 3
Column A
Apple
Banana
Orange
Peach
I would prefer a VBA solution that will not require any user input and happen in the background. This table will feed into PowerPivot (no duplicates, no blanks, etc.) Any help is appreciated.
Thanks
Bookmarks