Add snipped to paste report in descending order

Hi,

I have a code that extract matched rows and copy to another sheet, But it copy on next empty rows But is copying on Ascending Order (bottom of last records).

I would like to make the change the copy/paste in descending order ( on top of last records)

The snniped that i need to add in the code is

Please Login or Register  to view this content.

This is the original threat:
https://www.excelforum.com/excel-pro...e-matches.html

and this is the original code

Please Login or Register  to view this content.

Thank you!!

Andy

Hi KebellaH,

Sorry to bother, but The Code is replacing previous Data, also is copying the header in "Test" tab on last row 1048576
What I need is to Copy on Top (Above of previous) Data and so on...

I realized that the matched numbers are pasting not in the same way, so I added a column with a Date in order to sort from.

Note: please i upload the latest sample wb with the code and the way it's displaying the output.


Thank you So much!!

Thanks Kebellah !!