|Please can someone write me a macro to create a new worksheet in Excel based on a trigger.|
Basically I have a master worksheet which is the first tab in the series containing some data. Column F has a drop down list containing two options "Completed" and "Pending". I want excel to create a new worksheet whenever a user selects "Completed" from the drop down list. The trigger will always be "Completed" and in case the selection is "Pending" then nothing should happen.
I don't know if its possible or not but I would also like the new worksheet created to be renamed automatically to data input in other cells. E.g. - If I user "Completed" in Cell F1 then the new worksheet created should be renamed to the data in Cell A1, B1 and C1.
Values and result for e.g :
Cell A1 = Jan 2011
Cell B1 = BACS
Cell C1 = Pre Flight
Result required = A new worksheet named "Jan 2011-BACS-Pre Flight"