How to delete rows using formulas
 

have a spreadsheet of employees' names, #'s, etc. I need to delete rows
and add new names, etc. The formulas says =+SUM(A73+1) for example. I can't
just highlight the row and delete because it gives me an error #REF!+1.
Please help.

Someone tried to help me but then I got the error #value!.

This is a numerical sequence 1,2,3, etc.

How to delete rows using formulas
 

Please stay in the original thread, Ron already posted a follow up there

--

Regards,

Peo Sjoblom

"Rere" wrote in message
...
have a spreadsheet of employees' names, #'s, etc. I need to delete rows
and add new names, etc. The formulas says =+SUM(A73+1) for example. I
can't
just highlight the row and delete because it gives me an error #REF!+1.
Please help.

Someone tried to help me but then I got the error #value!.

This is a numerical sequence 1,2,3, etc.