Create a individual sheet in Excel...

Hi All,



I have an excel sheet contains some data with drop down option.
So my request is here I need a macro when I click the “Generate” button each and every drop down list can be generating an individual excel sheet and stored the same location stating the name of drop down selection (Eg: Please refer the Result sheet – CTS). Hope this helps.


Thanks/Raju

Hi PaulM100,

Thanks for your response, This Dropdown.xlsx excel sheet is a Parent sheet so my question is i need a macro the Dropdown selection needs to be change automatically and generate the new excel sheet based on the drop down list.

Eg Apple Inc it could be save as a same location the file where stored (Dropdown.xlsx) in the name of Apple inc.xlsx like wise the others as well CTS.xlsx, TCS.xlsx. so i needed the For loop when i select the "Generate" command button option.

Hope this helps.

Thanks/Raju