View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Embyr42 Embyr42 is offline
external usenet poster
 
Posts: 1
Default Creating a Fill In form that populates a table

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