Short answer: Use a free Google Apps Script that splits one big list into a tab per region, rep or any other column, in one click. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Put the list on a Data tab; Paste the script; Run it; Run it again after changes; Give each person their own tab.
How to set it up
- Put the list on a Data tab. Put your full list on a tab called Data, with a header row.
- Paste the script. Open Extensions, then Apps Script, and paste in the code below. At the top, type the name of the column to split on, exactly as it appears in your header. The example uses Region.
- Run it. The first time it runs, Google asks for permission because the script works in your own account. Review it and allow it; that only happens once. A tab appears for every value in that column, each with the header and only its own rows.
- Run it again after changes. Add rows and run it again: the tabs are refreshed instead of piling up copies.
- Give each person their own tab. Pair it with protected ranges so each person can edit only their own tab.
Want this set up for your business? Free written scope in 20 minutes
Get the script
Download it free
We'll email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Ready-made copy
A Google Sheet with the tabs and the script already in place: click Make a copy and it works.
$19 one-time, emailed straight after payment.
Have us install it for you
We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
$49 one-time.
Questions
What does this script do?
It is a free Google Apps Script that splits one big list into a tab per region, rep or any other column, in one click.
How do I set it up?
In 5 steps: 1. Put the list on a Data tab; 2. Paste the script; 3. Run it; 4. Run it again after changes; 5. Give each person their own tab. The full steps are on this page.
Is it free, and does it send my data anywhere?
It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.
Can you install it for me?
Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
Want this connected to the rest of your tools? Send us a short brief.
Pushbuild · Automate your business with Pushbuild: pushbuild.com/