hi alls,

i am having a problem in creating new worksheet automatically when i change my selection from drop down list.


To be clear, i have a list from January to December in my drop down list. I would like excel help me to create a worksheet with a name "January" when i select January from drop down list.

Thanks in advance. I am a beginner in excel. help to have a step by step explanation from you all.