Drop Down?
 

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

Drop Down?
 

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

Drop Down?
 

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

Drop Down?
 

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

--
Regards,
Tom Ogilvy


"THE_RAMONES" wrote in message
...
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