Hi Everyone,
I am trying to find a solution for the below.
I have 2 separate spreadsheets that users fill in however, that populate a another workbook. For example the user on form 1 enters their Surname and DOB. On the second Form they then enter their Surname, address and contact number.
Form 1 auto populates the workbook, but I would like Form 2 to search and match the Surname, and then input the address and Contact number on the same line as the username.
I am trying to find a solution for the below.
I have 2 separate spreadsheets that users fill in however, that populate a another workbook. For example the user on form 1 enters their Surname and DOB. On the second Form they then enter their Surname, address and contact number.
Form 1 auto populates the workbook, but I would like Form 2 to search and match the Surname, and then input the address and Contact number on the same line as the username.
