Validation source on another worksheet

M

Matt

Can I make a drop down menu and list by using the source
from another sheet. If so how?
Also will the INDIRECT function and VLOOKUP work from
another worksheet?
 
K

Ken Wright

Yes , Yes and yes. For the validation, name the range on the other sheet, and then when you get
the option to go select a validation list, type in =your_rangename
 
Top