G Guest Jun 26, 2004 #2 Data Validation Allow = List Source = The range you wish to use in the drop down Harry
J John Michl Jun 26, 2004 #3 If your list is in a different sheet, you'll need to name the range and use that instead of the direct reference. - John www.JohnMichl.com
If your list is in a different sheet, you'll need to name the range and use that instead of the direct reference. - John www.JohnMichl.com
D Don Jun 26, 2004 #4 Hi, Take a look here, it explains the entire process: http://www.contextures.com/xlDataVal01.html HTH, Don
Hi, Take a look here, it explains the entire process: http://www.contextures.com/xlDataVal01.html HTH, Don
