Autofilter, Copy to New Worksheet, Highlight

[maplehollow]

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!

[arlu1201]

It will be good if you explain with the help of a sample file -

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.