Filtering

Hi

I am working with a large spreadsheet that has approx 98000 rows to start.

I have formatted as a table and added auto filters. When I have applied the auto filters there are 24000 cells left visible.

When I attempt to populate or copy paste cells with in the filtered range I receive a message telling me that the range is too complex and I should try and get the data in to one continuous rectangle.

Catch 22 is that I need to be able to copy paste in the filtered range in order to sort in to a continuous range.

Any thoughts?

Thanks