Dropdown menu

S

Sir Paul

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.
 
B

Bob Phillips

You can refer to another sheet if you use named ranges (Insert>Name>Define
Name...), or the INDIRECT function (INDIRECT("Sheet1!A1:A10))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
G

Gord Dibben

Sir Paul

Lists don't have to be on the sheet.

Have the lists on your Master sheet and give them Names from
Insert>Name>Define.

Use the Name in your DV source dialog box.

i.e. =MyList


Gord Dibben Excel MVP
 
S

Sir Paul

WOW guys, thanks, this will make my sheets easier and with faster files too,
not so much detail to carry on each of my 20 sheets, in total I had 90 names
in three different lists per sheet,

thanks
 
Top