Copy List to Next Empty Row

**JOGIER** · 07-15-2009, 02:54 PM

I recorded the following Macro to copy Data to a Database Sheet, but cannot get it to find the next empty row. When I run the macro it will paste to whatever row the cursor is in. I would like to have the data copied to the next empty row starting with column "A2". Also (this may need another thread) I would like a formula in Column A to automatically record a new number with each new entry, starting with say 0001.

Thanks,

Jim O

Please Login or Register  to view this content.

**shg** · 07-15-2009, 03:11 PM

Try this:

Please Login or Register  to view this content.

**Mase123y** · 07-15-2009, 03:17 PM

Please Login or Register  to view this content.

Also works.

**JOGIER** · 07-15-2009, 03:25 PM

shg,

That seems to be the ticket. Now if I want to have each new entry with a different "ID" number in column "A" I would assume a formula of some sort would need to be included somewhere in the code. Can I address that now or should I start another tread?

Jim O