View Single Post
  #1   Report Post  
pQp
 
Posts: n/a
Default 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