Hi All,
I would like to copy data from one sheet to another using (vba or macro).
Attahced is the spreadsheet, which has 3 sheets:
1) USD
2) AUD
3) Rate
I would like to copy the data from USD sheet to AUD sheet straight away, but column D to P in USD should multiply with the amount in cell RATE'B6. (the rate B6 in "RATE sheet")
(For e.g: if USD is 2, AUD will be: 2 x 1.03 = 2.06).
Note: The amount of rows can vary in USD sheet.
Please Help.
cheers,
Talha
Bookmarks