Copy a specific row and a range of columns to next available row on another worksheet

**monkey1184** · 11-29-2013, 04:38 PM

Hi

I am trying to copy a specific row number with a range of columns to the next available row on another worksheet.

This is what I have right now:

Please Login or Register  to view this content.

However, it does not seem to know where I am referencing. Anyone have ideas on how to solve this?

**GC Excel** · 11-29-2013, 04:43 PM

Hello,

Difficult to test without seeing your workbook...
Something like this maybe :

Please Login or Register  to view this content.

**monkey1184** · 11-29-2013, 05:02 PM

Basically I think I can get it I know how to reference a specific row with a range of columns.

Re: Copy a specific row and a range of columns to next available row on another worksheet