1.Can you please help me with the macro to copy paste the filter area to another work sheet .
2.Also the tab from which it is copying the tab in the new sheet must be named same .
3. And the crieteria based on which iam filtering .. need my new sheet to which data will be posted to be named same.
Example in my sheet which is Cricket top 5 selection .In tab 1 i have a mix of players from europe , asia & SA who are just batsmen , .Tab 2 i have only bowlers .... say tab 1 is named batsmen , tab 2 as bowlers ets...
I need the new sheet to have data about only England players .So i need my new sheet names as England players .The new sheet should have tab 1 named as batsmen & tab 2 as bowlers etc...... .Like this my sheet should be segregated based on location .