Drop Down?

[THE_RAMONES]

I have a workbook that contains 40 different worksheets all of which are
different reports. I would like to set up a report map page to make it a
little easier for the user to navigate. Basically would like to set up
groups.

Hierarchy would be
Organization
Business unit
Vendor
Site


So if I picked a particular business unit only that business unit's reports
would be listed in the drop down list. If someone could get me on the right
track I would appreciate it. Thanks

Ramon

[Tom Ogilvy]

http://www.xldynamic.com/source/xld.Dropdowns.html

--
Regards,
Tom Ogilvy


"THE_RAMONES" wrote:

> I have a workbook that contains 40 different worksheets all of which are
> different reports. I would like to set up a report map page to make it a
> little easier for the user to navigate. Basically would like to set up
> groups.
>
> Hierarchy would be
> Organization
> Business unit
> Vendor
> Site
>
>
> So if I picked a particular business unit only that business unit's reports
> would be listed in the drop down list. If someone could get me on the right
> track I would appreciate it. Thanks
>
> Ramon
>

[THE_RAMONES]

Do I use hyperlinks in the last drop to take the user to actual report page?
Thanks

"Tom Ogilvy" wrote:

> http://www.xldynamic.com/source/xld.Dropdowns.html
>
> --
> Regards,
> Tom Ogilvy
>
>
> "THE_RAMONES" wrote:
>
> > I have a workbook that contains 40 different worksheets all of which are
> > different reports. I would like to set up a report map page to make it a
> > little easier for the user to navigate. Basically would like to set up
> > groups.
> >
> > Hierarchy would be
> > Organization
> > Business unit
> > Vendor
> > Site
> >
> >
> > So if I picked a particular business unit only that business unit's reports
> > would be listed in the drop down list. If someone could get me on the right
> > track I would appreciate it. Thanks
> >
> > Ramon
> >

[Tom Ogilvy]

No, you would use the click event to trigger code to take them there.

--
Regards,
Tom Ogilvy


"THE_RAMONES" <[email protected]> wrote in message
news:[email protected]...
> Do I use hyperlinks in the last drop to take the user to actual report
page?
> Thanks
>
> "Tom Ogilvy" wrote:
>
> > http://www.xldynamic.com/source/xld.Dropdowns.html
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "THE_RAMONES" wrote:
> >
> > > I have a workbook that contains 40 different worksheets all of which
are
> > > different reports. I would like to set up a report map page to make
it a
> > > little easier for the user to navigate. Basically would like to set
up
> > > groups.
> > >
> > > Hierarchy would be
> > > Organization
> > > Business unit
> > > Vendor
> > > Site
> > >
> > >
> > > So if I picked a particular business unit only that business unit's
reports
> > > would be listed in the drop down list. If someone could get me on the
right
> > > track I would appreciate it. Thanks
> > >
> > > Ramon
> > >