Forum Discussion
Automatic table rows based on cell value.
I wonder if there is a function to create a table with number of rows and columns based on data in cells. For example, if I put in a cell that I want 4 rows and 6 columns, a table is automatically generated with 4 rows and 6 columns.
Is this possible?
4 Replies
No worries, How I envisioned it is that I will fill in the exercise, amount of sets (total rows) in a kind of form and enter submit and this will create a table that can further be filled. Once the table is created it can't be changed because submit will reset the fill in form and you can only create a new table with new exercise and amount of sets that will skip a line and follow. Maybe that is possible with a script or something like that but I haven't seen how to on the internet. This link is the closest I came.
https://www.youtube.com/watch?v=UXzOlBI_Zk0&t=1s&ab_channel=KenjiExplainsMaybe some more explenation. I would like to use this for my training plan. For example I want to fill in another table some information (exercise Squat, sets 6 etc.) and this wil translate/create the table as seen below.
I'm sorry, I don't see how that would work.
What should happen if you change the value of one or both of those cells afterwards? Should the table be resized? That would cause a problem if you have already entered data in the table.
