I have created a userform which sends the data to a worksheet (works OK)
What I want is to add more data to the WS on the next available row. At the moment it just keeps overwriting the previous input in row2 (row1 has headings). I believe it works via xlup. or something like that.
Can anyone help?
Colin.
What I want is to add more data to the WS on the next available row. At the moment it just keeps overwriting the previous input in row2 (row1 has headings). I believe it works via xlup. or something like that.
Can anyone help?
Colin.