Hi,
I have created a validation list. Well, all I need is a drop down list but using the validation option is the only way i can seem to do it. Basically, what I want to do is select something from the list and when I do that for my page to scroll down to where that list referfers to e.g
Amsterdam
Paris
Munich
If the information on Munich is in the range A16:D20, when I click on Munich in the list (A1) I want the page to move to where the range is.
Is that possible? I am using Excel 2002 by the way. (work computer)
Thanks Folks! Look forward to seeing some help!
I have created a validation list. Well, all I need is a drop down list but using the validation option is the only way i can seem to do it. Basically, what I want to do is select something from the list and when I do that for my page to scroll down to where that list referfers to e.g
Amsterdam
Paris
Munich
If the information on Munich is in the range A16:D20, when I click on Munich in the list (A1) I want the page to move to where the range is.
Is that possible? I am using Excel 2002 by the way. (work computer)
Thanks Folks! Look forward to seeing some help!