Hi guys
I am trying to cycle through all the worksheets in my workbook and copying all the unique values from Column C into a new worksheet.
Is there a way to get a macro to do that instead, and then paste it in a new worksheet so that:
- the other worksheet name is in the header and,
- relevant unique Column C values from that worksheet is listed below it?
Example:
This way I can tell what values are present in each worksheet without having to open each one.
Thanks!
I am trying to cycle through all the worksheets in my workbook and copying all the unique values from Column C into a new worksheet.
Is there a way to get a macro to do that instead, and then paste it in a new worksheet so that:
- the other worksheet name is in the header and,
- relevant unique Column C values from that worksheet is listed below it?
Example:
Worksheet1 | Worksheet2 |
AAA | AAA |
BBB | CCC |
DDD | FFF |
EEE |
This way I can tell what values are present in each worksheet without having to open each one.
Thanks!