Selecting more than two items in an AutoFilter

OK, please interrupt me where I can improve on processes.
As part of my macro, I need to select ten items in my table of data to import into another worksheet.

Is there a way to select more than two if I edit the macro code itself? I tried but it didn't seem to work, by extending the line to include further Criterion:

Please Login or Register  to view this content.

OK, here's a sample file.

basically, say I want to automate a copy-paste of only "Fuel Sales", "C-Store Sales", "car Wash Sales/GP", "SALES", "GROSS PROFIT" - how would you do it?
I'll need to macro-ize it, too.


My two thoughts:
a) Learn how to do a filter function which can do more than two variables
b) Learn how to specify relative cell references in rows (i.e. "down one row")

Hi

Use the advanced filter. With your example file run the following code.

Please Login or Register  to view this content.

rylo

Hi

Open your example file, ALT F11, Insert, Module, paste the code, run the code, then view the output on sheet2.


rylo

Ohhhh didn't realise it output the files into Sheet2!

Now I gotta see if I can butcher this code into a macro of sorts...

Thanks again, you're my hero rylo