Hi All, I hope you can help. I'm using Excel 2003. I have one workbook wich
contains many worksheets. These worksheet contain information regarding our
conference rooms (what equipment, facilities, phone No's Etc). What I would
like to do is to create a drop down list containing all the names of our
conference rooms. When a room is selected I want all the information to be
displayed. I know I can select all the cells I need in a workbook and give
them a name (name range). So is it possible to link options in a drop down
list to these name ranges and then display them on the same sheet as the drop
down list.

I'm still getting to grips with this so am pretty much a novice, if there is
a better way of doing this then I'm all ears. Any help would be greatly
appreciated.