Excel: How can I move data from a form into subsequent rows in a.

[NNIGuy]

I have created a data entry area in Excel. I am trying to use Excel macros
to transfer the data to another area in the same spreadsheet, creating
several rows of data that can be exported all at once. I can't get the paste
special command to automatically use the next empty row to transpose the
data. I have tried using combinations of the end, up arrow, and down arrow
keys to go to the next empty row. When the macro is run, it always ignores
the end and arrow key commands and goes back to the original cell chosen when
recording the macro. It always uses the same location and overwrites the
data from the last input. Are there macro commands that can be used to paste
special to subsequent empty rows?

 

[JulieD]

Hi

if you'ld like to paste the current code that you have we'ld be happy to
look at it for you.

Cheers
JulieD

 

[Guy R!]

I don't have the macro with me. I'll have it this evening and send it.
Thanks for responding.

Guy R!