B
bondtang
I want to create a macro that can check the currency and convert it to
others. For example ;
Original
A B C
John USD 100
Peter EURO 200
Charles HKD 700
Result
A B C D E
John USD 100 HKD 780
Peter EURO 2000 HKD 2000
Charles HKD 700 HKD 700
Thanks in advance.
Bond
others. For example ;
Original
A B C
John USD 100
Peter EURO 200
Charles HKD 700
Result
A B C D E
John USD 100 HKD 780
Peter EURO 2000 HKD 2000
Charles HKD 700 HKD 700
Thanks in advance.
Bond