Filter Double Criteriai

[webmax]

Hi

I have a excel sheet which contains the raw data

I want to filter the two criteria which is region and location

The same will save in the Active path with the region name as file name

i am attaching the raw data and output file.

regards
Shahul

 

[Luke M]

Check out Ron's template codes for doing this using AutoFilter. you could easily add another filter on your data as needed.
http://www.rondebruin.nl/win/s3/win006.htm