Question: how to copy from one excel sheet to another with filter?
Answer: Activate sheet 2 (where the data goes) Choose Data > Advanced Filter. Select the List Range on sheet 1. Select the Criteria range on sheet 1. Select the radio button: Copy to another location. Select the Copy to range on sheet 2. Click OK.