I have an Excel spreadsheet with about 55 worksheets. Most of the worksheets have 100+ lines. I am creating a list of numbers that meet a specific criteria. I went through the spreadsheet and red-highlighted all the numbers I need. Now I want to make a list of unique values.
I'd like to make some kind of formula/macro/VB Code that goes through each of the 55 worksheets, and lists all of the numbers that are highlighted in red. Is there a way to do that without needing to browse each of the worksheets and copy the red cells, and paste them into a list?
(The next step will be to eliminate the repeated values, but I can probably handle that step.)