Insert Form Data to next row of table

[[email protected]]

Hello,

I am sure that there is a simple answer to this. I have a user form where data is entered and once complete i need to append the entered data to the end of "Table1". Wihtout the table I am able to use XlUp and offset each entered value to get the results i need. as soon as I create a table the data is spread over multiple rows.

The code i have for each user form value is: -

Please Login or Register  to view this content.

I have tried the following to enter the data into the last row of Table1 but it only puts the dat ain the header row and does not select the last row in the table. each user form value has a difference column header

Please Login or Register  to view this content.

Any help is greatly appreciated, Thank you.

[Logit]

.
Here is a sample, basic database project that does what you are wanting.

Study the code and apply it to your situation.

Please Login or Register  to view this content.

[Glenn Kennedy]

I do hope your username is not your REAL email address, unless you want a lot of spam, offering "unusual" services....

[torachan]

Attached simple UserForm
See the ADD button routine for code adding rows to tables.
@Logit, the 'COUNTA' method only works if there are no blank cell or as often happens some people have blank rows above their tables.
torachan.

[[email protected]]

Many thanks to all,

Both option have resolved my issue.

Thank you

[Logit]

.
Glad you have an answer. Best wishes.