Re: Drop down list

[Dhimit]

Re: Drop down list

Hi,

Is it possible to create a DROP DOWN list in a CELL that picks up values stored in a different worksheet.

In short, i want to create a DYNAMIC pop-list or drop down list.

Dhimit

 

[Lewiy]

You will first need to “name” the range in the other worksheet. Highlight your list of values, then Insert>Name>Define and type in a name, e.g. myrange. Hit ok.

No select the cell where you want the drop down list to be and go to Data>Validation on the Settings tab, change the “Allow” box to “List” and in the “Source” box, type:
=myrange

Hope that helps!

 

[Dhimit]

RE:

Thanks Mate,

I've followed the steps, but the Poplist only displays the Name of the range & NOT the values ?!

I did exactly what you said, highlight the list of values, name the range, etc,etc..

Dhimit

 

[jongooligan]

Have a look at this formula as a starting point. It defines a named range in sheet BB, column G.

=OFFSET(BB!$G$1,0,0,COUNTA(BB!$G:$G),1)

It is dynamic so any additions or deletions are reflected in the drop down list I'm using for data validation.

 

[Lewiy]

Did you type
=myrange
including the equals sign?