Hello,
I would like to copy the contents of FILTERED Column A (part of a table) on Sheet1 and paste to Column A (not part of a table) on Sheet2 (starting at A2). Here's the catch: I only want to run the script on the visible cells, and I only want to copy over one occurrence of any repeated record (e.g., if Oranges shows up twice, I only want it to be on Sheet2 once.
I haven't been able to get far at all and any help is appreciated.
Bookmarks