98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » PivotTables
PivotTables
Resolved · Medium Priority · Version 2007
Mon 4 Oct 2010, 15:27Delegate Ian said...
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
Tue 12 Oct 2010, 09:18Trainer Jacob said...
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:The Easiest and Quickest Way to use Autosum in Excel 2010Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature. |
