Does anyone know how to do this please
I'm using Excel Office 2007 and want to be able to goto a named worksheet by making a selection from a drop down list.
eg

The drop down list contains the names of coach trips and on selection of a trip the relevant trip worksheet is selected.

So selecting Lightwater Valley from the drop down list would automatically goto Lightwater Valley named worksheet