Hi

When you name your cells, you need to prefix the name with the sheet ref eg
sheet1!top, sheet2!top etc
Hope this helps.

--
Andy.


"Trevor Heywood" <Trevor wrote in message
...
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?