Help with cell referenceing

[Dab]

I'm trying to create an excel sheet that adds a number of segment duration
times together to provide the total time for all segments. No problem.

Then I calculate the start time and end time for each of the segments. The
start time is calculated using the end time of the previous segment. The
end time is calculated by added the segment time to the start time. No
problem

But... When I cut and insert a row cells containing the segment start, end,
and duration time, the sheet gets all screwed up as the relative cell
reference are adjusted for the newly inserted line, and I don't want them to
be. I can't use an absolute reference, or I end up with the same cut and
paste problem

Is there a way to turn off how a relative cell reference changes when you
move the cell?

For instance, I want a cell to be equal to the cell above. If I move the
first cell, I want it to be equal to the cell above, in it's new location,
not the old one. I thought that there was a referencing mode for this but I
can't find any information on it.

Thanks for any advice.

Dab

 

[Dab]

Thanks harald. This is what I wanted.

Dab

Hi

You can't turn it off. But this formula returns the value of cell above no
matter where you put it (except in Row 1, there it errs):

=INDIRECT(ADDRESS(ROW()-1,COLUMN()))

--
HTH. Best wishes Harald
Excel MVP
Followup to newsgroup only please

them but

 

[Harald Staff]

Doh !
Neat, Harlan. Never crossed my mind, thanks.

Best wishes Harald
Excel MVP

Followup to newsgroup only please.