Reply To: How do I automatically create tabs with specific custom information?

[Fiona Bellinger]

Do you hear my scream of satisfaction when I got it to work 🙂 🙂 🙂

Thanks Rob, I have used one of the tutorials by Alice Keeler which uses a template as well as a tab creater.  And that combined with a little script referencing the Tab name as a cell from which data is selected means it is all automatic now.  No stuffing my wrist 🙂

I’ve cleaned and shared my spreadsheet if you want to see it at work.  Just run the Template Tab at the top.

https://docs.google.com/spreadsheets/d/11E0nS37SpmcBM0eSmRn6Je55QOjQOWyu6bn6z9OAYHQ/edit?usp=sharing

The final (i hope) thing is that I want to protect all but one of the spreadsheets.  Not a biggy but if I can have read only for majority of the tabs it would save potential corruption and means that the people who have access to it can only enter data in one place.  Prob being is that I really can’t be bothered going in and individually locking all tabs, and it wont do it automatically based on the Template Tab being locked.

Again, thanks Rob and Emma for your help and encouragement.

Fiona