how do i populate a dropdown menu from another tab in my workbook

[Roger Govier]

Hi Shaun

Debra Dalgleish has some excellent instruction on how to do this at
http://www.contextures.com/xlDataVal05.html

 

[Debra Dalgleish]

If you name the range on the other sheet, you can refer to it in the
data validation dialog box. There are instructions here:

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

shaun wrote: