hi everyone

having an issue with a complicated excel sheet to display patient status and discharge status at the hospital i work at....

i have a series of formulas that add up length of stay and days till discharge, as well as copying a series of cells onto a second sheet to create a print out

when patient are moved from one bed to another, im finding that the formulas either follow the patient and thus show calculations not for the correct patient in the same row, or give me a #ref error


Ive tried putting in $ signs to stop them from moving but they seem to move regardless...

ive used a macro to repair upon command when this happens, but im also using it as a shared workbook and the users are not able to turn sharing on or off....well they can do it, but i would really really prefer them not to...

is there a setting in excel i can use to stop the formulas from jumping around when ever they want?