VBA to autofilter in a specific column for each criteria and copy the result to a new sheet

[kishorenaidugurram]

Need to filter on each region (Column F) and copy the result to a new worksheet. would be helpful if this can be done through looping as the original data set contains more regions. Thanks for the help
https://drive.google.com/file/d/0B02dDRY-jgk8Yks0bG5nbDlvME0/view

thanks

 

[My Aswer Is This]

You want to filter column and copy each row that meets your criteria to another sheet.
We need to know the criteria and the sheet name to copy to.

I never click on links so please do not say look at my file provided and figure it out.

And explain why you think you need a loop.
If we are filtering more then one sheet we need all those sheet names unless it all sheets.

We need filter from sheet name and filter to sheet name.