Creating a Fill In form that populates a table

[Embyr42]

Hi,
I am trying to create a front end user form that then poplulates into the
columns on the next tab with a macro.
I can get the macro to take the first line of data over to the next tab, but
I can't figure out how to get the macro to then go to the next available row
to populate the data of subsequent entries, it is simply replacing the data
of the first row each time.

How do I correct this error?
Thanks

 

[Otto Moehrbach]

You should post the code that you have so far. A general answer to your
question would be to set a range, call it, say, Dest, that would be the cell
into which you will paste what you copied. Then every time you paste, you
would add a line of code like:
Set Dest = Dest.Offset(1)
This would apply if your code was in a loop.
If you are copying/pasting one time in each cycle, you can find the next
empty row with something like:
Set Dest=Range("A" & Rows.Count).End(xlUp).Offset(1)
HTH Otto