Named Box linked to a Name

  • Thread starter Joey Spreadsheets
  • Start date
J

Joey Spreadsheets

Is it possible to have the name in the 'Named Box' be linked to a specific
cell so the name of that list changes if you change the name of that cell?
 
S

Shane Devenshire

Hi,

Give use more detail about your specific needs. Forget the Name Box, that
is just where you see the name of a range or enter a new name. It may be
that you want to look at the INDIRECT function, but I'm not clear enough
about what you want to say more.
 
S

Sheeloo

Not sure what you want... Pl. provide more details with examples...

Default names of cells are like A1, B1 etc...
 
D

Dave Peterson

That namebox will show a name for the selection. So you'd have to change the
selection each time you updated that cell.

Is that what you'd want?

If you're working with names and struggling to see what each name refers to, do
yourself a big favor and get a copy of Jan Karel Pieterse's (with Charles
Williams and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp
 
F

FSt1

hi
not sure but IF i understand you, the answer in no.
named ranges are aliases you assign your ranges. a range or cell can have
more than 1 name. (not sure if there is a limit.) named ranges can overlap.
if you want to change the name of one of your named ranges, you have to
delete the old name and add the new. you can add new names in the name box
but to delete you have to do that in the add names dialog.
2003 on the menu bar>insert>name>define.
not sure were it is in 07.

post back if i misunderstood.
Regards
FSt1
 
J

Joey Spreadsheets

I am looking for a easy way to create the Named Boxes, without having to type
them in, but rather reference a specific cell that would contain the name. I
have about 200 different rows that I want to define the names for their
ranges so I can use them with a dropdown via Validation (a question I posted
& got an answer to yesterday). Do I have to define each of the 200 ranges
individually by typing in their names or is there a simpler way?

Example of the data: Column A contains the name of the range I would like
to use. Columns B thru M have the items I want to have included in the list.
There are 200 rows going down with different items going across the columns.
 
D

Dave Peterson

Maybe...

Put the names in row 1 of each column.
Select the range (all the columns)

In xl2003 menus:
Insert|name|create|check create names in top row

(Make sure the values in row 1 are valid names.)
 
J

Joey Spreadsheets

SWEET! It worked! Thank you so much. This will save me a lot of time!
 
D

Dave Peterson

It may have worked for you, but I wonder if it's really the best way to go.

But I don't think you've shared enough to get any other suggestions (well, if
you wanted some).
 
Top