Copy certain hidden template depending on option selected from drop down list

Hi,

Hope you can help, I don't even know where to start/if this is possible.

I've got a "Hole Location" sheet which contains a drop down list with different options in it, eg. window sample, trial pit and inspection and corresponding hidden worksheets for each option.

What I'm trying to do is copy the hidden sheet which corresponds to the option selected in the drop down list and insert it as a visible sheet after the Hole Location sheet. The process then repeats for the next row.

Hope you can help

Hi.

Thanks for your reply, attached (hopefully) is a cut down version of the spreadsheet.

The Trial Pit and Dynamic Sample spreadsheets will be hidden and the first tab will be "Locations". I've mocked up what I'm after as you mentioned, BH01 and BH02 are both set as Dynamic Sample so the Dynamic Sample template has been copied and renamed BH01 and BH02 for each. The same occurs for TP01 and TP02.

Many Thanks

Hi,

That's brilliant, thank you!! I've noticed a couple of things while using it, do you know If there is a way to add additional sheets? I.e. I have put in BH02 and BH04 and clicked create sheets, however I then need to add BH03. I've tried reclicking Create Sheets but get a run time message (I'm guessing because it's trying to reproduce sheets which already exist). I know it will also probably be a couple of lines, but when the templates are hidden, the new sheets are also hidden. How would I unhide the new sheets?

Thanks again

Hi,

Thanks again. I'm hoping to add the extra sheet (a copy of the template sheet ideally) and leave the prexisting ones alone as they will likely already be filled with data. I've managed to solve the hidden sheet issue by basing it around your code which is great thank you (just making the entire sheet visible).

Hi,

Thanks again. I'm hoping to add the extra sheet (a copy of the template sheet ideally) and leave the prexisting ones alone as they will likely already be filled with data. I've managed to solve the hidden sheet issue by basing it around your code which is great thank you (just making the entire sheet visible).