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
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,113,850
Messages
5,544,656
Members
410,627
Latest member
georgealice
Top