Hello hello!
Here's the challenge.
A form will need to expand to as many as 50 rows/line-items but typically will have just 5 - 10 items. So, we don't want to always have a 50-line form.
Most cells are text. There are some formulas but the challenge is the Combo Boxes.
What would be good ways to allow users to "add a row" and have the combo boxes automatically assign themselves?
Note: The Input Range will not change no matter how many rows. The Cell Link is the one that needs to point to the new row.
Say, the Input Range is $K$5:$K$15
The last line has a combo box in C17 and the cell link is D17
The "add a row" feature needs to include the combo box in C18 and cell link in D18.
Ideas? Questions??
Here's the challenge.
A form will need to expand to as many as 50 rows/line-items but typically will have just 5 - 10 items. So, we don't want to always have a 50-line form.
Most cells are text. There are some formulas but the challenge is the Combo Boxes.
What would be good ways to allow users to "add a row" and have the combo boxes automatically assign themselves?
Note: The Input Range will not change no matter how many rows. The Cell Link is the one that needs to point to the new row.
Say, the Input Range is $K$5:$K$15
The last line has a combo box in C17 and the cell link is D17
The "add a row" feature needs to include the combo box in C18 and cell link in D18.
Ideas? Questions??
