"link" two or more comboboxes

[Sessions]

I'm a wee bit confused... I've read this below:

The first thing that needs to be done is name the lists. Select th
countries, without the title, and name it COUNTRIES. Next, select al
cities (Again without titles) from USA and name it USA. Continue thi
process for every country.

Now, let's assume that the first list appears in A1. Go to Data
Validation, Select List, and in "Source" put

=COUNTRIES.

Make sure that "In-cell dropdown" is checked.

Now, if the second list appears in B1, go to Data, Validation, agai
Select List, and in "Source" put

=INDIRECT(A1)

If Excel returns an error, don't worry, you don't have anythin
selected in A1. To test it, select a country in A1, and now, when yo
click in B1 you should see only the cities from that country.
---------------------------------------------------------------------------------

My question comes from the first paragraph. It says "Select th
countries, without the title, and name it COUNTRIES. "

Where and how do you 'name' it??

In my case "Countries" would be "Departments" and 'cities' would b
'Foreperson'

any clarification would be appreciated

Attachment filename: tardiness report02.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=40260

 

[Dave Peterson]

You can name ranges, but selecting the range and typing the name into the
namebox--that box to the left of the formula bar.

Or via Insert|Name|Define.

See Debra Dalgleish's site for some nicer instructions:
http://www.contextures.com/xlNames01.html

For the dependent lists stuff, you may want to read Debra's notes:
http://www.contextures.com/xlDataVal02.html

or just start at the beginning:
http://www.contextures.com/xlDataVal01.html

 

[miker1999]

You name lists by using the drop down box on the far left of the formul
toolbar. It probably currently has the name of whatever cell you ar
in. Just type in that box to name lists