I NEED TO HAVE A DROP DOWN WINDOW IN CELL A1 TO POPULATE A LIST TO B1, B2,B3
AND B4

Please drop the CAPS and describe what you mean by "populate a list"

What type of choices would you have in the A1 dropdown and how would that
determine what goes into B1:B4

Where does(do) the B1:B4 list(s) originate?


Gord Dibben MS Excel MVP

On Fri, 15 Feb 2008 20:02:01 -0800, ELBERT
wrote:

I NEED TO HAVE A DROP DOWN WINDOW IN CELL A1 TO POPULATE A LIST TO B1, B2,B3
AND B4

First, name the cells B1 to B4 :
by selecting B1 to B4 and going to the top left screen and write a
name for them ( ex. LIST ).
Second, select A1 then on the top menu select DATAVALIDATION
On the setting tab dropdown to LIST
then in the second box write " = LIST" without quotations.
Check "ignore blank" and "in-cell dropdown"
Click OK and try it.
"Gord Dibben" wrote:

Please drop the CAPS and describe what you mean by "populate a list"

What type of choices would you have in the A1 dropdown and how would that
determine what goes into B1:B4

Where does(do) the B1:B4 list(s) originate?


Gord Dibben MS Excel MVP

On Fri, 15 Feb 2008 20:02:01 -0800, ELBERT
wrote:

I NEED TO HAVE A DROP DOWN WINDOW IN CELL A1 TO POPULATE A LIST TO B1, B2,B3
AND B4