We have two tabs
Tab 1 is a form and is pulling information from row 2 to populate the form. The form has a lot of formulas that are applied and I am not adding those to the attached example.
Tab 2 is a list of loans (a workflow of sort) with information that needs to populate the form on tab 1. We work the loan on row 2 and then once we are done we delete the loan and row 3 becomes row 2.
We need the loan that was on row 3 and is now row 2 to populate the form on tab 1.
We are getting a ref error after we delete row 2.
I attached a sample of what part of the form looks like.
Is this making any sense?
Bookmarks