Hello,
I have a sheet(A) that contains several references to another sheet(B). I use it for staffing purposes so I need to be able to drag the cells on sheet (B) around while the not breaking the formulas. In other words, on sheet A, M38 always references 'sheet b!G32' Even if I drag G32 to another location leaving the cell blank, then my results should be blank rather than #REF!
Bookmarks