Drop down lists?

[Guest]

Hello,

I am fairly new to advanced excel use. Here is what I am trying to do:

I want to create a master list of names on sheet 1. On sheet 2 I would like
150 cells in column 2 to each have a drop down box that allows me to choose
one of the names in the master list on sheet 1. I know this can be down and
cannot find how. Please help!!

Thank you

 

[Debra Dalgleish]

You can use Data Validation to create the dropdown lists. There are
instructions in Excel's Help, and here:

http://www.contextures.com/xlDataVal01.html

 

[Gord Dibben]

Tim

Select the range of cells on Sheet1 that contains the list.

Insert>Name>Define. Enter a name like MyList and OK your way out.

On sheet2 select 150 cells, say A1 to A149.

Data>Validation>Allow>List. Check "in-cell drop-down". Type =MyList in
"source" dialog box and OK your way out.

Each of A1:A149 will have a drop-down arrow and the list of names from Sheet1.

Gord Dibben Excel MVP

 

[Gord Dibben]

How about A1:A150<g>

Gord

Tim

Select the range of cells on Sheet1 that contains the list.

Insert>Name>Define. Enter a name like MyList and OK your way out.

On sheet2 select 150 cells, say A1 to A149.

Data>Validation>Allow>List. Check "in-cell drop-down". Type =MyList in
"source" dialog box and OK your way out.

Each of A1:A149 will have a drop-down arrow and the list of names from Sheet1.

Gord Dibben Excel MVP

 

[Ken Wright]

Hi Gord - I just assumed you were using Winzip to compress the numbers into a
smaller space <g>

 

[Gord Dibben]

No.

Just my convoluted arithmetic......1 + 149 = 150

Gord