Home |
Search |
Today's Posts |
#1
|
|||
|
|||
PIVOT TABLE + HYPELINK: Mission Impossible ?
IN PIVOT TABLE, I WANT ONE OF THE ROW FIELDS TO BECOME ALL HYPERLINK. IS
THIS POSSIBLE ?? ALSO CAN WE MAKE THE VALUES HYPERLINK TOO ?? Example, the role field is fruits. Page field is country. For US, we have orange, apple. For UK we have pears and lemon. The fruits need to be hyperlinked. Eg apple is underlined and hyperlinked and when users select US, both apple and orange are clickable and when users click on apple it takes him to the page describing what apple is (of course in reality it is not apple but something else). |
#2
|
|||
|
|||
Hi hkappleorange,
You might try using a worksheet change event to select a range based on the row field data. Something like this will work if you set ranges named 'apple' etc in the workbook. Put the code in the code page for the worksheet that holds your pivot table. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) ' change the column no that of the pivot table row field If Target.Column = 1 Then ' select a range named same as row field value Range(Target.Value).Select End If End Sub You may need to include a bit of error trapping :^) Ed Ferrero http://edferrero.m6.net/ THIS POSSIBLE ?? ALSO CAN WE MAKE THE VALUES HYPERLINK TOO ?? Example, the role field is fruits. Page field is country. For US, we have orange, apple. For UK we have pears and lemon. The fruits need to be hyperlinked. Eg apple is underlined and hyperlinked and when users select US, both apple and orange are clickable and when users click on apple it takes him to the page describing what apple is (of course in reality it is not apple but something else). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |