VBA solution for currency change in different columns

[mpatino]

Hi guys,

wondering if someone could help me get a VBA solution for my currency exchange to different currencies. I am travelling to different countries so I am expending money in different currencies, however, I'd like to have a column where I can see how much did I pay in USD. This is an example of what am I doing:

Date	$	₡	र	£
Nov-07-14	35.94		2,030.47
Nov-08-14	10.71		605.12
Nov-08-14	10.71			17.00
Nov-09-14	29.00	15,776.00

<tbody>
</tbody>

So, I'd like to have a VBA to help me convert to USD in column B no matter if I enter a value in columns C, D or E

Thank you,

 

[SteveO59L]

What makes you think that you need a VBA solution for this?

 

[Rent23]

Try in this way:

	A	B	C	D	E
1			₡	र	£
2		Fx Rates $	544	56.4961	1.5873
3
4	Date	$	₡	र	£
5	11/07/2014			2030.47
6	11/08/2014			605.12
7	11/08/2014				17
8	11/09/2014		15776

<tbody>
</tbody>

I have calculated the Fx Rates dividing the amounts in your table. For example the Fx Rate $/£ 17/10.71 = 1.5873 ecc

In Cell B5 copy the following formula:

{=INDEX(C5:E5,MATCH("*",IF(ISNUMBER(C5:E5),TEXT(C5:E5,"General")),0))/INDEX($C$2:$E$2,MATCH("*",IF(ISNUMBER(C5:E5),TEXT(C5:E5,"General")),0))}

enter it with Ctrl+Shift+Enter.

Then scroll down for all the $ amounts that you want to calculate.

 

[mpatino]

Thanks a lot my friend, this works really appreciate your help.