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.