• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

Enhancing the Currency Macro

EE Pros,

I have a great macro that several EE Professionals have worked on and most lately Gowflow has done a great job refining it.  But there is another aspect to this model.  What this model does now is based on selecting a Currency, it does a look up and conversion and placement of the converted value in specifically referenced cells.

In addition to what it does now, I need it to recognize when a USD Value is changed (Column H in "Currency" Tab), it ALSO updates the conversion value (in Column I) and reflects that change in the referenced cells.

Attached is a file with illustration on what is missing.

Thank you in advance.

B.
Copy-of-Currency-Update-and-Disp.xlsm
0
Bright01
Asked:
Bright01
  • 2
  • 2
1 Solution
 
gowflowCommented:
Will this work for you ?
gowflow
Currency-Update-and-Displayv11.xlsm
0
 
Bright01Author Commented:
Gowflow!  Excellent work.  Thank you......quick and precise.  I will be adding some additional "ask" questions to enhance this as I begin to scale it but for now this certainly fits the bill.

Thank you for jumping in AGAIN!

B.
0
 
gowflowCommented:
your welcome. Glad we could assist pls do not hestitate to post a link in here for any help you may need down the line.
gowflow
0
 
Bright01Author Commented:
Gowflow,

Next "turn of the crank" -- I need to be able to scale this by adding more reference cells and USD values that get converted and placed.

I've authored another Question at:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28335162.html

B.
Copy-of-Currency-Update-and-Disp.xlsm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now