Automatically filling a sheet from an existing sheet

Ask for Help
1

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.

2

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

3

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.

4

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.

5

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!

6

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