Pivot tables

Hi Susan,

Thank you for your question.

Open the spreadsheet and click somewhere within the data set of one of the tabs and use the following keyboard shortcuts:

Alt+D followed by P should bring up the pivot table dialogue box that use to appear in 2003. Now choose 'Multiple Consolidation Ranges' and decide whether to have a page field added or not. Highlight the first range and click Add and then add the second range from the other sheet and click Add.

It will then create the pivot table for you.

Please find the link below to a YouTube demonstration:

http://www.youtube.com/watch?v=ZBn1-r0I5oE

I hope this helps and answers your question.

Regards

Simon