# Automatically filling a sheet from an existing sheet

**URL:** <https://community.glideapps.com/t/automatically-filling-a-sheet-from-an-existing-sheet/80829>\
**Category:** Ask for Help\
**Created:** [March 18, 2025, 11:51pm UTC](https://community.glideapps.com/t/automatically-filling-a-sheet-from-an-existing-sheet/80829 "2025-03-18T23:51:18Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![GSW](https://avatars.discourse-cdn.com/v4/letter/g/a3d4f5/32.png) [@GSW](https://community.glideapps.com/u/GSW)\
**Post date:** [March 18, 2025, 11:51pm UTC](https://community.glideapps.com/t/automatically-filling-a-sheet-from-an-existing-sheet/80829/1 "2025-03-18T23:51:18Z")

</div>

Hello. Newbie here, still just getting the hang of things.

I have a Master Table and want to make Sub Tables based on it. One column in the Master Table is “Categories,” and the Sub Tables will be category-specific. I want each Sub Table to be automatically filled with the same data as the Master Table, but limited to a specific category.

Could you please point me in the direction of information on how to do this? Or advise on what to do? In the meantime, I’ll keep searching and reading.

Thanks very much in advance.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 19, 2025, 12:59am UTC](https://community.glideapps.com/t/automatically-filling-a-sheet-from-an-existing-sheet/80829/2 "2025-03-19T00:59:07Z")

</div>

One question: Why do you need these sub tables though?

---

<div class="post-metadata">

**Author:** ![GSW](https://avatars.discourse-cdn.com/v4/letter/g/a3d4f5/32.png) [@GSW](https://community.glideapps.com/u/GSW)\
**Post date:** [March 19, 2025, 1:23am UTC](https://community.glideapps.com/t/automatically-filling-a-sheet-from-an-existing-sheet/80829/3 "2025-03-19T01:23:46Z")

</div>

Thanks very much for responding. I want the sub tables in order to filter data (in this case, quiz questions) by category for easier handling.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 19, 2025, 1:36am UTC](https://community.glideapps.com/t/automatically-filling-a-sheet-from-an-existing-sheet/80829/4 "2025-03-19T01:36:20Z")

</div>

I think you can filter it on the front end, opposed to storing them in sub tables, which means you have the same piece of data in two places.

---

<div class="post-metadata">

**Author:** ![GSW](https://avatars.discourse-cdn.com/v4/letter/g/a3d4f5/32.png) [@GSW](https://community.glideapps.com/u/GSW)\
**Post date:** [March 19, 2025, 2:07am UTC](https://community.glideapps.com/t/automatically-filling-a-sheet-from-an-existing-sheet/80829/5 "2025-03-19T02:07:51Z")

</div>

Thanks once again for your kind response. You’re right - I am able to filter at the front end, but… let me try and explain my situation. (Sorry - it’s hard for a beginner to express clearly!)

1. The front end runs on a Helper table that pulls the next unanswered question from the Questions table. This is based on the question number column in the Questions table.
2. The quiz is set up so that you answer one question, then press the “Next Question” button and go to the next question. Again, this action is based on the question number column in the Questions table.
3. The “Next Question” action triggers the next unanswered question in the Questions table regardless of category, so when the front end view is filtered by category, if the next question is in a different category, the screen goes blank.
4. The reason I thought Sub Tables might be a good idea is because if I have category-specific Sub Tables, I can easily set up Helpers to pull from those Sub Tables based on what I already have. I mean, it’s probably not the most efficient method, but it’s something I could manage at my beginner level.

Thanks for your help!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 19, 2025, 12:43pm UTC](https://community.glideapps.com/t/automatically-filling-a-sheet-from-an-existing-sheet/80829/6 "2025-03-19T12:43:11Z")

</div>

I think you can keep your setup there and just add a filter for the viewing category, on top of the number?