Copy one sheet to another with macros and multiply numbers when copying

[talhawahab]

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

[kvsrinivasamurthy]

Pl see attached file.

[arlu1201]

Use this code -

Please Login or Register  to view this content.

[talhawahab]

Thanks Arlu. your code works great!!

[talhawahab]

Use this code -

Please Login or Register  to view this content.

THanks Arlu