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.