excel pivot table : is it possible to display details on single click of cell in same sheet
- by bala
I have an excel pivot table
the pivot table contains rows like
Status-count
open-10
closed-100
in progress-50
Now, on click of the count cells, is it possible to display the relevant details in teh same sheet?
or
is it possible to write a macro to popup a messagebox with the row information?