Let me know what I am missing...
1. I use this formula =IF(+'Order Journal'!B16="", (""),(+'Order
Journal'!B16)) to reference a cell on another worksheet.
2. On the 'Order Journal' sheet I delete out the row 16.
3. the formula does not continue to reference B16 -which is what I want it
to do- instead it gives me a #REF error - =IF(+'Order Journal'!#REF!="",
(""),(+'Order Journal'!#REF!))
4. I thought if the formula was relative it would always reference B16 no
matter what cell, row, column was deleted on that worksheet.
thanks in advance for help. Ricky