Sir Paul

Lists don't have to be on the sheet.

Have the lists on your Master sheet and give them Names from
InsertNameDefine.

Use the Name in your DV source dialog box.

i.e. =MyList


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 21:05:02 -0800, "Sir Paul"
wrote:

Data Validation is the way to go, use it regularily.

Ensure that you list criteria of what must appear on the pull down is
somewhere on your sheet, I have yet to find a way where I can have a master
sheet with all my detail.

"Debra Dalgleish" wrote:

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

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


ghost1967 wrote:
Is there a way to make a custom dropdown list for a column or group of cells?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html