Hello -

I have a table with four headers (columns) that I want to be able to folder the data with: Date, Province, City, Type

Each header has multiple different fields under it. Lets say there are 3 possible options under each header.

I want to be able to write a macros that will allow selection of up to 3 criteria in each header and selection from up to all four headers.

The inputs to select the criteria would be drop down lists such that the input form would have three lists under each of the four headers and the user could choose which critieria to apply by selecting from the drop downs.

Can someone help me with this? Its beating me.


Thanks