Advanced Filter VBA code

Hi,

Nembie to excel and VBA, i am looking for a code to perform an advanced filter when a command button is clicked and transfer the data to a new sheet, is this possible? it is a very basic operation i am looking for, see attached sheets.

Any help would be greatly appreciated!

Thanks in advance

Paul

Just do it in Excel with the macro recorder on, it will create the code.

Hi Bob,

Thanks fast for the response, i have tried that but it doesnt seem to work???? Most likely operator error!!!

I have attached the spreadsheet would this help anymore?

Many thanks.

Regards

Paul

You need to insert a column B on the second sheet with a heading of 'Letter', then use

Please Login or Register  to view this content.

Hi Bob,

Thank you so much for the assistance! Works perfectly.

Many thanks.

Regards

Paul

The trick here is that when you want to filter the data onto another sheet, that sheet has to be active. Don't know why, just know that is the reality