Creating Multiple sheets from a Master Sheet.

[Susmita Sahoo]

Hello,

Can we create multiple sheets from a master sheets?

I mean many chlid sheets from a parent sheet.

Thank You

Sushmita

[Laurie J. Nason]

If you mean create multiple tabs from a master tab in one google sheet, then yes.

If you mean create separate multiple google sheets from a master google sheet, then yes.

In short yes!!!! I regularly use both of these methods - the trick it to get the template to do the hard work for you - and then if necessary to use copy & paste as values to fix the data in either the tab or the sheet once you have the copy made.

Laurie

------ Original Message ------

From "Susmita Sahoo" <sahoosu...@gmail.com>

To "Google Apps Script Community" <google-apps-sc...@googlegroups.com>

Date 17/06/2022 08:07:17

Subject [Apps-Script] Creating Multiple sheets from a Master Sheet.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/01b0cf01-94aa-43f4-a06f-6ed8cec0648bn%40googlegroups.com.

[Susmita Sahoo]

Can u plz brief it Step wise

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/em69735de3-d939-46e6-846f-99cddbed4031%405ba8057e.com.

[Brian Pugh]

Alice Keeler has an extension that will do this quickly, easily, and very well.

Brian Pugh, IT/Educational Technologies Associated Hebrew Schools | Danilack Middle School p: 416.494.7666, | e: bp...@ahschools.com w: www.associatedhebrewschools.com 252 Finch Ave W., Toronto, ON M2R 1M9

This email is confidential and is intended for the above-named recipient(s) only. If you are not the intended recipient, please delete this email from your system. Any unauthorized use or disclosure of this email is prohibited.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAOgGbqCJ58Qs-0qHCaVz6NCw0VWY6Wmboeb%2Bik5Mz%3DHa6V_5VA%40mail.gmail.com.

[Витя Коледа]

вс, 19 июн. 2022 г., 13:15 Brian Pugh <bp...@ahschools.com>:

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAJBn2DRca%3DbzQ7gLXCqFtthnNy_npi9wHotobYjez7s_z8AFoQ%40mail.gmail.com.

[Remco Edelenbos]

Yes, but with this context we cannot give a proper answer. You can use IMPORTRANGE() formula to keep the data in sync.

[game over]

https://fabform.io/a/how-to-find-google-sheet-id