I have two worksheets. One has formulas based on data in the other.
How can I delete a cell of data - i.e. it is not needed, but not have to change the formula in every cell?
I can I could o out the cells and hide them, but I would rather get rid of the reference to the cell altogther.
How can I delete a cell of data - i.e. it is not needed, but not have to change the formula in every cell?
I can I could o out the cells and hide them, but I would rather get rid of the reference to the cell altogther.