I have created a button on sheet1 that opens a userform, this form has a textbox which displays the clients name and a textbox where notes can be added about the client.

When I click the 'add notes' button I would like to save the data to another worksheet with the clients name in column A and the notes in Column B. Because there are a number of clients I would like a new row for each client, and if i was to add more than one note to a client it would add the note rather than create a new row.

I hope this makes sense.