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.