I suspect you've created worksheet-level names rather than
workbook-level names. Select the worksheet where you
created the names, and bring up the Insert/Names/Define
dialog. Look for the "missing" name in the list: if I'm right
you should see it there with the sheet name to the right.

You can refer to such names in another sheet by prefixing
with the sheetname, e.g.

=Sheet1!MyName

but it's probably best to fix the problem at source by
deleting the rogue worksheet-level name and recreating
it as a workbook name. This should happen automatically:
I've never quite got to the bottom of how worksheet-level
names sometimes appear "accidentally" - it can happen
when you copy a sheet within a workbook but possibly at
other times too.

Andrew


Timmy Mac1 wrote:
Tearing my hair out here.

I have a spreadsheet operating with a number of worksheets. On one of
the worksheets I have highlighted a table of data and using INSERT -
NAME - CREATE option, used the labels on the top of the columns.

My problem is that when I go to use one of the names in a sumproduct on
another sheet, its as if it doesn't exist!

When I insert a new worksheet and use it to paste a list of the names
I'm using, it misses out the names pertinent to three or four of the
column names.

However, when I'm on the sheet itself, it shows the name I need for my
formula and lists it when I paste the names. It also shows it in the
name box when I highlight the range.

There appears to be nothing untoward about the names I'm using. For
example the one I need is -IssuingPolicyNo- with no spaces before or
after it.

Does anyone know why this is happening? It's driving me nuts!


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=573060