Sorry I haven't explained my problem that well. Here it is:

Line: Date Port 1 Port 2 Port 3
A B C D E F G H I
10
11 1/20 10 x x 20 x x 30
12 1/21 8 x x 22 x x 35
13 1/22 15 x x 18 x x 25
14 Last Line 1/23 12 x x 25 x x 20
15 (data added daily, or 5 rows at a time weekly)

20 12/31 14 15 40
21 1/23 12 25 20

What I want to know is how to move the 1/23 values in Row 14, Columns B, C,
F, I, etc. down to Row 21. The rows after Row 14 are added sometimes daily,
but more often weekly at which time I add 5 rows at a time. I want to move
the values in the last line entered down to row 21 (which of course will also
move down as I add more rows each day).

The "Last Line" is my invention. With the function ROW(A14), I can obtain
the number 14. So I wanted, for instance, to put the Cell Reference of
+C(=ROW(A14)), which would be "C14" in my mind, into C21. I found
that if I move the"Last Line" text/cell in Column 1 with a "Cut" and Paste,
the reference in the ROW function will change to the last/current location
of where Last Line is pasted. So all I would have to do is move "Last Line"
to the last row and I am in business.

It all works out in my mind, but Excel doesn't see it my way. Can anyone
tell me what I am doing wrong, or how to get this to work, or give me a
simple solution on how to tackle this priblem.

Thanks.
--
Ron Smith in Round Rock