(Solved) – Automatically populating excel or google sheets tables [closed]

  • by

I’m looking to use lists of x and y values to create multiple tables that will change accordingly when a value is added, deleted, moved, or changes. Imagine having the lists below:

 ---------- ---------- ---------------- -- 
| Material | Building | Infrastructure |  |
 ---------- ---------- ---------------- -- 
| Brick    | House    | Road           |  |
| Stone    | Tower    | Tunnel         |  |
| Cement   | Capitol  | Bridge         |  |
| Dirt     |          | Foundation     |  |
 ---------- ---------- ---------------- -- 

Now I want to use these to make every table possible given the three variables.

  1. Material (rows) – Building (columns)
  2. Material (rows) – Infrastructure (columns)
  3. Building (rows) – Infrastructure (columns)

So imagine 4 different sheets. One with the table in the code block, and then one for each of the tables listed above. For the three tables above, I’d like to add values in manually.

Now I’ve found ways to create the tables from the get-go, but the issues arise when I want to add items to the original list. If I add a new material (Asphalt) in between Brick and Stone, then everything will shift in the tables and all of the values for Stone will be on assigned to Asphalt and so on. What I would like to be able to do, is link everything so that when I new value, as explained above, is added, and whole new row is added and everything sticks together.

Does anyone have an easy solution for this? I’ve thought up some ways I could VBA or Google Apps Scripts it, or even run a customized program on it, but I feel like there has to be an easier way. Let me know what your thoughts are. Thanks.

** Disclaimer: this is a simplified example of what I’m trying to do. I have 10 different lists of variables that would create upwards of 50-100 tables that I want to be able to constantly adjust.

Leave a Reply

Your email address will not be published. Required fields are marked *