Dollar/Euro/Pound Excel macro
In EXCEL 2003, i am transferring data from Sheet1 to Sheet2. The data
includes one of the three currency signs ($,ぎ,ﾂ｣) in column 1 each time.
Can anyone help with a macro that will read the currency sign and then apply
that currency sign and format to other cells in the same row (C,D,E)- the
same process being repeated each time a new row of data is added.
e.g.
A B C D E
F
1 $ 25.00 $ 67.05 $ 98.00 $ 102.85
67.00
2 ﾂ｣ 34.00 ﾂ｣ 57.64 ﾂ｣ 87.00 ﾂ｣ 111.45
54.00
3 $ 198.00 $ 58.97 $ 25.00 $ 68.30
258.00
4 ぎ 62.57 ぎ 85.21 ぎ 58.00 ぎ 98.35
5.00
5 ﾂ｣ 7.54 ﾂ｣ 1.50 ﾂ｣ 69.00 ﾂ｣ 0.65
4.65
etc
Many thanks for all the advice given - this is a steep but fascinating
learning curve!
Yendorian
|