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

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

Hi Shaun

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

--
Regards

Roger Govier


"shaun" wrote in message
...

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

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

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

shaun wrote:

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html