I'm wondering if it's possible to use a macro to create a button to copy and paste filtered information on Sheet1 to a specific destination on Sheet2? Sheet1 contains two tables that can be filtered through many columns. Whatever combination of filters used I'm trying to use a button to copy the visible filtered data in both tables to cell A2 on Sheet2. I want to avoid copying the headers for both tables.

I've attached a sample sheet. Sample 7.xlsx

Thanks in advance.