Copy the sheet based on ComboBox Value Selection

[nawas]

Hi,

I have excel sheet with a comboBox values, i need to copy the sheet as new and add to the tab whenever select a value.

is that achievable..


Appreciate your supports...

[tigeravatar]

Hello nawas,

you can do this with a combobox_change event. However your question is very vague. Can you please be more specific with what you're looking for?

[nawas]

Sorry I couldn't explain well.. i've attached a sample sheet. You will see a dropdown right side.. whenever a name selects the form should be copied in a new sheet or tab with the same format..

Some time the drop down list will have more than 10 names..

Thanks for the supports..

[nawas]

Any luck on this...

[tigeravatar]

Hello nawas,

The drop-down list is not a combo-box, it is a data validation: List cell. So to do what you want, you will need VBA utilizing the Worksheet_Change event:

Please Login or Register  to view this content.

[nawas]

Thanks a lot tigeravatar... very much appreciated..

However, is it possible to get the same page layout for the copying sheets..also need to remove dropdown list from copied sheets..