Hi,
I am hoping that someone can help me.
I am trying to update a Master sheet of data using forms. The Master sheet is partially-populated and each line of data has some empty cells. The Master sheet has over 200 line items, but the individual lines are grouped by unique group IDs.
Specifically, I am trying to create the following:
- A form in which a user enters a single unique group ID into a field on the form.
- Then, I would like the form to pull in every line of data with the same group ID on the Master sheet and display all of the associated lines in the form.
- Then, the user should be able to manually populate any empty cells and/or edit any populated cells in each line that was pulled in and displayed in the form.
- Finally, the user should be able to, then, submit the form with the newly-populated / edited cells that were pulled in by the unique ID and update the Master sheet of records.
If you need any further clarification, I can provide more details.
Thanks in advance!