Hi Everyone,
I'm hoping I can find at least some good pointers on how to accomplish this. I've uploaded an example xlsx (Excel 2007) file to help illustrate what I need done.
I have a workbook that has multiple columns (labeled "Table 1" in the attached example). I need to generate a list of unique values based on two of the columns in Table 1 (example output labeled "Table 2" in example).
The columns that make the output list unique are Column 1 and Column 4. You'll notice that the cells that have 'GHI' in my example are output twice because Column 4 in the table has two different values (3333 and 4444)...
On top of generating this unique-list, it has been requested that the new table (Table 2) be output to a brand new spreadsheet.
The icing on top....
We are expecting to get this data regularly and it would be nice to write a macro to do this for future iterations, automatically.
Any help is very appreciated. I will be continuing to figure this out on my own, but a some help would be great.
Thank you for reading
CJR
Bookmarks