I have a fantastic little macro that MartinLiss and FanPages (FP) wrote for me and I need a small change. I've attached the model and I need the SELECTION of the Currency to be on the first WS ("Customer - Input") instead of where it is now ("Currency" WS). I have mocked up the F2 Cell in the desired location (in Green) and all I'm looking for is to select the Currency from the drop down menu, on the first worksheet (in Green Box) and have the macro work correctly (which it does now if you select the Currency in D4 of the "Currency" WS (which can be deleted once the fix has been done).
Thank you in advance,
[Title modified by SouthMod]