Selecting certain rows from worksheet to appear on another worksheet

[ReportMaster]

I know that there has to be a simple way to do this, but I have not been able to figure it out. Say I have ten columns of info and 500 records. One column contains a month name while another has a year. How could I create a worksheet that would display only the records from a unique combination of month and year?

Also, is there any way to do this dynamically? ex. have two combo boxes and depending on the selection from each, only the matching information would appear on the "filtered" sheet.

Thanks for help!!!

 

[PHV]

Take a look at the AutoFilter object.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[xlbo]

Have a look at Data>Pivottable
Put Year and Month as PAGE fields and organise the others to suit

You will then be able to select a year and a month and the rest of the data will be filtered to those constraints - PAGE fields act like filters and (kinda) look like combo boxes

Even better, you can use the feature "Show Pages" to create 1 page per unique item eg 1 page per month - and it's automatic !!

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question