Using non defined names from another sheet
I think I'm missing a vital point here. I often use existing (not defined)
labels to reference cells or calculate values on a sheet. Can I also do this
from a different sheet without defining ranges by somehow adding the sheet
name in the reference? (Tried a few permutations of this idea but always get
a #name? error.)
TIA
|