PivotTables

Resolved · Medium Priority · Version 2007

Mon 4 Oct 2010, 15:27 Delegate 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:18 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

The Easiest and Quickest Way to use Autosum in Excel 2010

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

1) Go to the bottom of the column of data.

2) Shortcut click in the column then Ctrl + down arrow

3) Use Alt + = for Autosum and press the enter key to complete.

View all Excel hints and tips