I am trying to create a system where outputs do not disappear when inputs are deleted, but are instead stored and collated in a new sheet. Is this possible? I am finding it quite difficult to articulate what I actually have in mind, so I'll use an example to illustrate this:
Let's say if I input 1 four-legged table, I get an output of 4 legs and 1 table top.
Now, when I delete the first input, and put in a second input for 1 six-legged table, my output becomes 10 legs and 2 table tops
And when I delete the second input and put in a third input for 1 four-legged table with a rotating tray, the output becomes 14 legs, 3 table tops, and 1 rotating tray.
When I'm done, I reset the sheet.
Let's say if I input 1 four-legged table, I get an output of 4 legs and 1 table top.
Now, when I delete the first input, and put in a second input for 1 six-legged table, my output becomes 10 legs and 2 table tops
And when I delete the second input and put in a third input for 1 four-legged table with a rotating tray, the output becomes 14 legs, 3 table tops, and 1 rotating tray.
When I'm done, I reset the sheet.