Forum Discussion
How to automatically create a variable number of rows on a linked sheet based on criteria
Hi, I am looking for a way to automate some entries my team is making. I am dealing with a one-to-many relationship. Below is a simple example of what I currently have TABLE 1 - Itineraries ...
apmulheran , Though with a series of tricky formulas this can be achieved, but i would suggest against it as the formulas are complex to understand and maintain in long term.
Attached template achieves this for upto 10 guests per 10 entries , transformation is done from Sheet1 to Sheet3 , Sheet2 is used for temporary calculation used to make Sheet3.
The whole thing breaks down if you rename Sheet2 or insert any rows or columns.
So as i said, if need is utmost, it can be achieved, but would suggest against it.