ok have attached document psag errors
on main sheet i moved bill brigs from room 6 bed 4 to room 5 bed 1
and jack johnson from room 6 bed 2 to room 5 bed 4
on the hand over sheet bill briggs and jack johnson are both still in the same beds, and ive got #ref on the beds they are meant to be in
even with dollar signs this happens the fomula on the hand over sheet that states where the cell gets its information from follow the cut and pasted name
and the location you paste to give you a #ref error code
|