Copying a row then moving to the next row in excel in preparation for copying

Occasional Visitor

I am trying to write a vba macro for copying a horizontal row in a sheet used for tracking, to a column in a working sheet.

The working sheet is then copied completely to a new sheet (I have already created this macro), that is numbered automatically from a cell in the new sheet.

I then want to go back, clear the working sheet, and then populate this sheet with the next row on the tracking sheet.

Any assistance would be appreciated, thanks

Related Conversations
Set Default to Copy and Paste Visible Cells Only
Karen Arigo in Excel on
2 Replies
How do I group rows in an excel table?
Marisa Medrano in Excel on
1 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies