vba filtered sort

[Danny54]

how do i return my data back to the original structure after applying a filtered sort?

I have some code that that filters a column, then sorts this data to be copied to a new sheet. I then disable the filter to do more filtering and copying. I found that after disabling the first filter, the data is not in its original layout.

is there some magic way of doing this?

I have thought of adding a temporary column with consecutive numbers, sort those first, then filter/copy, then resort on the consecutive numbers and onto the next filter.

Seems to be a strange way of doing this. Any suggestions would be helpful.

 

[Fluff]

Adding the row number into an empty column & using that to re-sort is how I tend to do it, if the data is unsorted to begin with.