Ian has attended:
Excel VBA Intro Intermediate course
PivotTables
Would you know if its possbile to select multiple cells in a pivot table and then use the showdetail command to open a new worksheet with the details for each of these 10 cells.
I'm trying to conditional format the top 10 values in the data and then select these using "GoTo" "Conditional formating" without much sucess.
Many Thanks
RE: PivotTables
Dear Ian
Thank you for your post and outline of what you are trying to achieve. Two of my colleagues who deliver our Excel VBA course has reviewed your post and feel that if any solution can be reached it is beyond the scope of the forum.
In these instances we ask you to send us your working files, we will then review and see if a solution can be reached.
If so we will inform you of the scope of work, development time required by the trainer and related costs. If you are in agreement we will then commence the work for you.
I have sent you an email and if you would like to discuss this further please let me know a suitable time to contact you.
Kind regards
Jacob
