Create a dropdown list from data that resides on another worksheet in the same workbook

[jtramell]

I need to create a drop down list from data that resides on the worksheet 'Request Names' in A4:A18 on worksheet '24 Hour Schedule' in cell B5. Any help.

Thanks
John T

 

[VoG]

You need to create a Named Range. See http://www.contextures.com/xlDataVal01.html