Problem copying Excel Table select columns with Autofilter to new sheet

[coloradomtns]

Hello. Need some help on this problem.

In Excel, I have a table ("Table1") on Sheet1, it has 18 columns.

I set a filter on 6 of those columns. No problem with this.

Next, I need to take those filtered results and copy certain columns to Sheet2. THIS IS WHRE I'M STUCK

I am trying to use something like for each column to copy:

Sheets("Sheet1").Range("Table1[[#Headers],[Name]").Copy Sheets("Sheet2").Range("A:A")

Note I need to copy only certain columns from Table 1 over to Sheet2. While the Autofilter is on.

Thanks in advance. T.