Hi guys,

I need a macro to copy all rows from one worksheet that contain any values in them to a different workbook and to appear under the last value that is entered in the worksheet of the different workbook.

So (I know this isn't right and doesn't copy only those rows with values in) but I have so far got:

Sub Copy_Rows ()
Sheets("Output").Range("7:7").Copy
Windows("Apparel Export.xlsm").Sheets("Sheet1").Range("D65536").End(xlUp).Offset(1, 0).PasteSpecial _
            Paste:=xlPasteValues
        Application.CutCopyMode = False
Any ideas how I can build on this and get it to work?

Thanks in advance for any help offered...

Two points to bear in mind:

I have the workbooks as a group so they will already be open, and the worksheet I am copying from has a header (made up of two rows) that I do not wish to copy.