Hello I am currently retreivng a list to which I add a sequence number and
from which Max() gives me the last record in the list.

Name Country Code Amount Sno
Mr x MRU M01 10.00 1
Mr y ROD R07 5.00 2
Mr z REU R08 5.00 3
Mr a MAL M11 10.00 4
Total 30.00 5

I need to copy these details to another sheet always starting with the last
line in the list and paste the remaining information in the original order.

I have been trying to use VLooup but it would not work everytime.

Thanking you for your help