Copy from one sheet to another using VBA
 

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

Copy from one sheet to another using VBA
 

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

Copy from one sheet to another using VBA
 

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