Ssaqibh wrote a very useful Currency Update Macro for me.
I have one change to make. The Attached Workbook works fine except the Currency update, within the WS/WB needs to take place WHEN THE CURRENCY IS SELECTED. What happens now is that when you fire the macro, it both updates the Currency Selection as well as updates the Currency Table. What I need is for the Currency to change Within the WB/WS and then when you fire the macro by the button, it then does the table update.