Pivot table

Hi Andy,

Thank you for clarify the question.

There is always a way in Excel.

It can only be done with a macro and I do not know how much knowledge you have with macros.

If you place the code below in the Visual Basic Editor and amend the code to fit your PivotTable it will do the job.

The line "Sub CreatePivotSheets()" will tell Excel that you want to create a macro with the name CreatePivotSheets.

The last line "End Sub" will tell Excel that here will the macro end. In the line "Sheets("Sheet1").Select" you will need the change the name of the sheet in which you have your PivotTable. If your sheet name is January change the line to "Sheets("January").Select".

The next line "For Each Cell In Range("b9:e9")" is a loop and in my example it will run through the cells B9, C9, D9 & E9. You will need to amend the line to define in which range you have the totals.

You will not need to do other changes to the code below.





Sub CreatePivotSheets()

Sheets("Sheet1").Select


For Each Cell In Range("b9:e9")
Cell.ShowDetail = True
Next Cell

End Sub




I hope that this can help you. VBA in Excel is magic and can do what ever we want to do in Excel.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector