C
carrera
I have the following formula as an example on a sheet called Summary....
=IF(ISBLANK(LocationOne!L18),"",LocationOne!L18)
The formula is copied down a range of rows from L6 to L75.
When I delete row 18 on the LocationOne sheet, it creates a row where the
#REF! is displayed. the formula in the cell above indicates L18, and the
formula in the cell below indicates L19....What is causing this extra row,
and how can I prevent it?
Thanks
=IF(ISBLANK(LocationOne!L18),"",LocationOne!L18)
The formula is copied down a range of rows from L6 to L75.
When I delete row 18 on the LocationOne sheet, it creates a row where the
#REF! is displayed. the formula in the cell above indicates L18, and the
formula in the cell below indicates L19....What is causing this extra row,
and how can I prevent it?
Thanks