UpdateDropDowns in module1 is the macro that should be executed. It calls Function DefValList & Function ColToLtr
You need to copy everything in module1 from the beginning to the just prior to sub test

The sub test can be deleted.