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

What does the after look like?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WINS" wrote in message
...
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

It would look like this

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

"Don Guillett" wrote:

What does the after look like?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WINS" wrote in message
...
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