Hi, new to this forum. Have been searching for a good few hours now and can't quite find a solution to my problem. I hope you can help.

I'm in the process of creating a database with several steps.


Step 1, name and address entry.
- I've set up a macro to extract the details from one sheet and add it to a table on a summary sheet by inserting a new row, cutting and pasting the data into seperate columns within the same row. i.e. A1 = Title - Name, B1 = Title - Address, C1 - Title, etc.. A2 = Name X, B2 = Address X etc.. When the user adds another entry from the form sheet, the table now becomes:
A1 = NAME, B1 = ADDRESS
A2 = Mr. Y, B2 = Address Y
A3 = Mr. X, B3 = Address X


My problem however starts when I want to fill in a third column (e.g. C1 = CUSTOMER RESPONSE) at a later stage from a separate sheet again.

The problem I am having is that I cannot think of how to add the step 2 data to the same row of data on the summary sheet from step 1.

Is there a way I could set up a separate sheet and have say a drop down menu of a step 1 entry as the first option and have a different form where a macro would be able to find the relevant row in the summary sheet and paste the new data into the correct cells?

I.e.

-user fills in step 1 form (name"X", address"X")
-user might fill in another step 1 form (Mr. Y, address Y)
-user clicks on a step 2 form, selects "X" from a drop-down menu, fills in step 2 form (response X, comments X, notes X etc.), clicks SUBMIT

All data filled into the step 1 form (data = "Mr. X") is transferred into a table on a separate sheet, where the macro inserts a new row on top for each new entry. I want the user to be able to fill in a step 2 form at any stage in order to add data to the same row of the ("Mr. X") step 1 data.

I could work with a macro that could recognise "Mr. X," find that text in the summary table and select the cell in say column 4. Effectively a VLOOKUP formula, but instead of copying the text from cell E5 to cell A2, select cell E5, then cut and paste step 2 form.

I'm really stuck here, I know it's a bit of a handful to understand, but any suggestions would be greatly appreciated.

Thank you

Dan