Hyperlink in Pivot Table?

pbthatsme

New Member
Joined
Dec 7, 2004
Messages
7
I have created a pivot table with 3 Pages (Group, Level, Area) to allow the user to select different views of data (Course, Organization). I would like the user to be able to click the course and be sent to the appropriate web page. I do not think this is possible, but I wanted confirmation on this.

If this is not possible, I am thinking I would have to create drop-down lists for each of the three items I mentioned in the Pages section and then have the appropriate data display based on that information. The problem is, I do not have the VBA experience to do this. Years ago I did learn VB so I am not totally unfamiliar with programming, but if there is someone who understands what I need to do and can direct me to some examples, I can try and use the code to do what I need.

Thanks, in advance, for your help.

p.s. I am using Excel 2000
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,140,944
Messages
5,703,305
Members
421,290
Latest member
james90

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top