VBA code required for copying rows from one tab to another

HI there

I am struggling to complete a code for the following:

Highlight all active rows which include data on one tab on a spreadsheet and copied across to another tab on the next available row. This is on the same spreadsheet

Thanks

Hello there,

The below code should work for you.

Please Login or Register  to view this content.

To use it press hold down the Alt key and press the F8 button. In the space provided for macro name clear the field and then type copyall. Then select the Create option.

In between the text Sub copyall and End Sub paste the above code.
Exit out of VBA. Anything that appears in green is a comment meant to help you understand the macro.

To run the code select Alt F8 again then this time select the copy all macro and select run.

Let me know if you have any questions.

Thanks!