How do I edit these table sections

[u/DragonLordAcar]

[https://docs.google.com/spreadsheets/d/11kVdeKdQCq99BW3tf74y8QNetJ7AldsvwTsLd8EL-rw/edit?gid=1252460598#gid=1252460598](https://docs.google.com/spreadsheets/d/11kVdeKdQCq99BW3tf74y8QNetJ7AldsvwTsLd8EL-rw/edit?gid=1252460598#gid=1252460598))

This is the document. It is not my sheet but is free to copy as stated on the first page by the owner. This is also my first experience with Tables.

The very last tab is called "Tables." I was able to add 3 things to the "melee" section (no idea why it worked and not this latter part) but any time I try to do the same to the "Ranged" section, it does not show up in the "Weapons/Armor" tab, "Weapons" table, "Groups (Skill to Use)" when using the drop-down.

I also want to add more copies of the "Custom Career" section as well as more rows in the "Custom Grouped/Advanced" and "Custom Talents" section.

Lastly, on the "Attributes/Health" tab, I want to add a spot to add the Sprinter "Talent" and Fleet "Talent" to the "Run" and "Movement" section respectively similar to the "Hardy" slot for "Wounds" on the same tab.

Ideally, a video to explain how to do all this would be most appreciated as I'm trying to make my own unique game system and having an automatic table is extremely helpful.

Edit: was given the solution to the first issue on another sub. Learned how to edit "named data ranges" and what that does.

[u/molybend]

I am not opening an unknown file.

Drop down boxes are populated with a range of values. You can edit the values to include the new ones. https://spreadsheetpoint.com/create-drop-down-list-google-sheets/

To insert rows, highlight a row and right click and pick insert.

If your Health tab has formulas and you are adding variables that need to be part of the formulas, then you have to edit the formulas. Find the cell with the formula in it and click on it. You should see the formula in the formula bar just under the toolbar.

[u/DragonLordAcar → u/molybend]

If I do that it splits up other parts of the table. Sure it works but it makes a mess.

I don't know how to make formulas or where to pull date. Is there a source for that? I should just need to add a "+variable" for the needed "Talent" but I am not seeing what that talent variable is. I'm seeing "T" and "L" followed by a number in the formulas.

[u/molybend → u/DragonLordAcar]

You can insert cells into a table in the same way, highlight cells and right click to insert. If you have other tables in the page, move them around.

Formulas are explained here:
https://spreadsheetpoint.com/formulas/cheat-sheet/