I would like to use the named cell references feature of Excel to make my
formulas easier to understand. I know how to update formulas when the named
cell is in the same worksheet, but when I try to apply the cell references
when the formula is in a different worksheet to the formula, it does not
work. Can you help?