Drop down lists?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
Click to expand...
 
Hi Gord - I just assumed you were using Winzip to compress the numbers into a
smaller space <g>
 
Back
Top