I have a multiple worksheets in my workbook. I want to name a cell on each
workbook by the same name "Litres" - note: I do NOT want a 3D reference to
all at once, but individual references.
On the same spreadsheet somehow I've managed this before - I have a name
"Business" that is context-specific on whichever sheet I happen to be on, but
I can't remember how I created it! Looking at at in the 'Names' dialog box,
it appears in the list as:
Business June
....where 'June' is the current sheet name. Can anyone help me with creating
a reference like this?