Question: how to copy filters from one excel sheet to another?
Answer: Select the area you want to filter., Display the Data tab of the ribbon., Click the Advanced tool, in the Sort & Filter group. ... , Set your filtering options as desired., Make sure the Copy to Another Location radio button is selected., Specify a copy destination in the Copy To field., Click on OK.