Hi, I'm having problems copying data back into a data Filter as I don't get the data to show as it should.
For example, I have 50 records, I filter it to 30 records and copy these 30 records to another excel sheet. Then, when I copy these 30 records back to the same filter, I don't get 30 records, I get around 20 records. Now, I know why this is happening, as the data is going to the hidden filtered data, but what I want to know is how do I overcome this problem, so that when I copy the 30 records back, I get them exactly in those 30 filtered records?

Thanks in advance.