Creating a Fill In form that populates a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Embyr42 - 24 Mar 2008 18:28 GMT

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

Reply to this Message

Otto Moehrbach - 24 Mar 2008 19:22 GMT

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

> Hi,
> I am trying to create a front end user form that then poplulates into the
[quoted text clipped - 9 lines]
> How do I correct this error?
> Thanks

Reply to this Message