Copy data in a row without referring to the row #

A

Art MacNeil

Hello,

Is there a way for a macro to copy data in a row without referring to the
actual row number? I have a spreadsheet with data on certain rows and I
want to copy that data to a new spreadsheet. The problem is the relevant
row numbers tends to shift over time. Today the data I need is on Rows 16,
29, 55, 70 etc. Over time these tend to change so in a few months the data
I need may be in Rows 16, 32, 59 and 85. Currently, my Macro for row 16,
looks like this:
Rows("16:16").Copy

I then copy and use Paste special to get that data.

Row 32 looks like:
Rows("29:29").Copy

I'd like to find a way to copy the current row, without referring to the row
number.

Any help would be greatly appreciated,

Thank you,

Art.
 
D

Dave Peterson

Activecell.entirerow.copy

???



Art said:
Hello,

Is there a way for a macro to copy data in a row without referring to the
actual row number? I have a spreadsheet with data on certain rows and I
want to copy that data to a new spreadsheet. The problem is the relevant
row numbers tends to shift over time. Today the data I need is on Rows 16,
29, 55, 70 etc. Over time these tend to change so in a few months the data
I need may be in Rows 16, 32, 59 and 85. Currently, my Macro for row 16,
looks like this:
Rows("16:16").Copy

I then copy and use Paste special to get that data.

Row 32 looks like:
Rows("29:29").Copy

I'd like to find a way to copy the current row, without referring to the row
number.

Any help would be greatly appreciated,

Thank you,

Art.
Click to expand...
 
A

Art MacNeil

Oh my. That was easy wasn't it. Can you tell I'm new to Macro's?

Thank you for your help,

Art.
 
Top