Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a Fill In form that populates a table
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 "Embyr42" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdown List that populates another column | Excel Worksheet Functions | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
Form Fill | Excel Worksheet Functions | |||
Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
how to get a data form to fill you own exel sheet (was data-form | Excel Worksheet Functions |