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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!