gunpowderboy
New Member
- Joined
- Jul 18, 2007
- Messages
- 3
I'm looking for a way of converting currency and I can't seem to find anything on the board (at least not that I understand how to implement...)
what I have:
Several times a week I get workbooks (all in different layouts) which contain both text and pricing.
What I need:
I need to be able to convert all cells which are formated as a specific currency (GBP, USD and EUR) into one of the orthr currencies.
What I think could be the solution;
A macro or something that performs like this (one fore ach currency) "IF A1:ZZ9999 is formated as currency (GBP) THEN add function =FOREX!C2* in same cell"
The reason fro the add fuction is that I need to be able to see the original numbers and update the exchage rate on a going basis.
Is this possible???
Thanks in advance
what I have:
Several times a week I get workbooks (all in different layouts) which contain both text and pricing.
What I need:
I need to be able to convert all cells which are formated as a specific currency (GBP, USD and EUR) into one of the orthr currencies.
What I think could be the solution;
A macro or something that performs like this (one fore ach currency) "IF A1:ZZ9999 is formated as currency (GBP) THEN add function =FOREX!C2* in same cell"
The reason fro the add fuction is that I need to be able to see the original numbers and update the exchage rate on a going basis.
Is this possible???
Thanks in advance