MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

List from other worksheet or workbook?

  Asked By: Charlie    Date: Feb 21    Category: MS Office    Views: 1451

I want to create a drop down list in the worksheets("sheet1").
The content of the list is from my database that I created at the
The most simple way for the drop list is fro the data > validation >
However it is not allow to create the list from other worksheets.

Pls advice. Is there any other ways to create the drop list from the
other sheet ??



2 Answers Found

Answer #1    Answered By: Mason Evans     Answered On: Feb 21

We've had success using named ranges for this.

Name the range that contains your list  on the secondary worksheet
(you may need to tweak your range if the length of the list changes
from your DB).

Set your validation  type to List and in Source field, simply type
='list name'

Answer #2    Answered By: Ludwik Fischer     Answered On: Feb 21

I too have been able to "trick" Excel into accepting a list
from another sheet  this way.

Didn't find what you were looking for? Find more on List from other worksheet or workbook? Or get search suggestion and latest updates.