Copy the data from this sheet to other sheet

[Closed]
Report
-
Posts
1
Registration date
Tuesday February 7, 2012
Status
Member
Last seen
February 7, 2012
-
Hello,

I have a problem about macro excel as:

I have the data in file excel:
Exam:
Vendor account Date Invoice Due date Amount currency Currency
FV01 24/10/2012 inv_test 23/12/2011 50,000 USD
FV02 01/02/2012 inv_test5 12/02/2012 60,000 USD
FV03 15/01/2011 inv_test3 15/01/2011 35,000 EUR
FV04 02/02/2010 inv_test1 20/11/2009 40,000 THB

I want to export the above excel to another sheet excel as:

Vendor account Date Invoice Due date USD EUR THB
FV01 24/10/2012 inv_test 23/12/2011 50,000
FV02 01/02/2012 inv_test5 12/02/2012 60,000
FV03 15/01/2011 inv_test3 15/01/2011 35,000
FV04 02/02/2010 inv_test1 20/11/2009 40,000
Total 110,000 35,000 40,000

Please help me as soon as possible. Thank you for your support .

1 reply

Posts
1
Registration date
Tuesday February 7, 2012
Status
Member
Last seen
February 7, 2012

you just press copy then yopu go directly to other page then you press paste.