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
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