copy row from one sheet to the next available row on another

[clarkie]

Hi Guys

I am trying to record a macro that will copy the information from one
row on one particular sheet (used daily) to the next available row on
another sheet.

Can anyone help. I'm fairly new at this but learning fast.

thanks

 

[Douglas J. Steele]

Your mention of "sheets" makes it sound as though you're using Excel.

This newsgroup is for questions about macros in Access, the database product
that's part of Office Professional. Macros in Access are nothing like what
are called macros in the other Office products. Assuming you are using
Excel, you'd be best off reposting your question to a newsgroup related to
Excel.