Hi, All,
I have spent several hours reading through forum threads trying unsuccessfully to find out how to build a macro for the following scenario:
I regularly work with spreadsheets with around 65K rows. I have to search column #1 of the spreadsheets for 40 or so values (12345 OR 23456 OR 34567, etc). Initially, I want the macro to autofilter for all of those 40 values. Then I want to copy those results to a new worksheet. Finally, I want the macro to highlight the rows on the new worksheet according to certain conditions. For example, IF a cell in column 1 = (12345 OR 23456) THEN Highlight those rows Yellow. IF a cell in column 1 = (121314 OR 131415) THEN highlight those rows red.
Thanks!