asked on

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

ASKER CERTIFIED SOLUTION

Jacques Geday

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bright01

ASKER

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.

Jacques Geday

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

Bright01

ASKER

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:

https://www.experts-exchange.com/questions/28335162/Scaling-a-Conversion-Macro.html

B.
Copy-of-Currency-Update-and-Disp.xlsm