Need Macro to Select All Files in a Column After Filter Applied

I am recording a macro to filter some data and then select the data in the column after filtering. When I record it and select the data, it gives specific coordinates in the coding rather than selecting all visible rows after the filter.


This is a problem because the filter will result in different rows each day, so the coordinates will not be the same as when I recorded it.

Example: I filter a column to show anything containing values of {19,20,21,22,23,24}. Rows 2 and 3 do not fit this criteria, so they are removed...therefore when I select the column to copy (excluding the title row), it starts specifically with row 4.


Please let me know if you need clarification on anything.

The help is much appreciated.