LinkBack URL
About LinkBacks
PGLeeM 
Am i able to enter a value in a cell in say GBP, and the value be automtically coverted to USD using an exchange rate held in another cell??
Am i able to enter a value in a cell in say GBP, and the value be automtically coverted to USD using an exchange rate held in another cell??
In the cell in which you type it? Not without VBA. In another cell? Yes, easily, using a lookup formula. Which do you want?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I basically need to create a spreasheet that converts value from GBP to USD. As im not the only person using it, I was hoping the values could be typed and converted in the same cell to avoid complication
That will need VBA - are you able to use macro-enabled workbooks on your network?
thanks for your response. yes as far as i am aware we can :-)
OK - I'll move this to the VBA section for you.
Great, thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks