Delete a row without dirupting the formulas in the following rows
 

I am making a schedule that is updated daily and each time I update it I have
to delete the rows that have been completed, but when I delete them all the
cells below that have formulas that once related to the cells in the row I
deleted all turn to "#value!" instead of just adapting to the new row that
was moved up and accepting those cells in the formula.

Is there anyway to make excel do that?

What I'm currently doing is deleting my rows and then highlighting the rows
below and dragging them up over the messed up formulas to correct them, but
that gets to be time consuming.

Any ideas?

Delete a row without dirupting the formulas in the following rows
 

As always you should post your formulas along with a clear explanation with
examples of what you need.
It sounds as if using row() might be useful.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Soulscream" wrote in message
...
I am making a schedule that is updated daily and each time I update it I
have
to delete the rows that have been completed, but when I delete them all
the
cells below that have formulas that once related to the cells in the row I
deleted all turn to "#value!" instead of just adapting to the new row that
was moved up and accepting those cells in the formula.

Is there anyway to make excel do that?

What I'm currently doing is deleting my rows and then highlighting the
rows
below and dragging them up over the messed up formulas to correct them,
but
that gets to be time consuming.

Any ideas?

Delete a row without disrupting the formulas in the following r
 

Sorry about that, maybe this example will help explain what i mean:

When you put this formula =IF(A1="","",A1+1) into Cell B3 and then you
delete Row 1, the cell in this instance turns to "#REF!"

Since the Row was deleted there is still an A1 cell, but the formula no
longer recognizes it. It now has the info that was moved up from A2 before I
deleted Row 1. I'm trying to figure out how to make my formulas adapt so it
will still work even though a row is deleted.

Does that make more sense?

"Don Guillett" wrote:

As always you should post your formulas along with a clear explanation with
examples of what you need.
It sounds as if using row() might be useful.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Soulscream" wrote in message
...
I am making a schedule that is updated daily and each time I update it I
have
to delete the rows that have been completed, but when I delete them all
the
cells below that have formulas that once related to the cells in the row I
deleted all turn to "#value!" instead of just adapting to the new row that
was moved up and accepting those cells in the formula.

Is there anyway to make excel do that?

What I'm currently doing is deleting my rows and then highlighting the
rows
below and dragging them up over the messed up formulas to correct them,
but
that gets to be time consuming.

Any ideas?