How can I change the column that is used to filter? In your example, you are using column C (or 3), but what if I want to use Column 17 (of 18). I changed the rows count from 9 to 18, but when I change this:

.Range(.Cells(2, 3), .Cells(.Rows.Count, 3).End

to

.Range(.Cells2, 17), .Cells(.Rows.Count, 17).End

The macro only copies the header row and not all the rows of data along with it. What am I missing there?

Thanks!