LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 66
Default Creating reports per Pivot Table PivotItem

I have a pivot table that cna be used to create reports per filtered PIVOT
ITEM.

my code jams when it trys to set the visible properties. Can you help?

Sub CreatePivotTabs()
'Create tabs per Pivot table
Dim x, y As Integer
Dim strLOB_NM, strHideLOB_NM As String

Sheets("Pivot Table").Select
With ActiveSheet.PivotTables("PivotTable1").PivotFields ("LOB")
For x = 1 To .PivotItems.Count
For y = 1 To .PivotItems.Count
If y < x Then
strHideLOB_NM = .PivotItems(y).Name
.PivotItems(strHideLOB_NM).Visible = False
Else
.PivotItems(y).Visible = True
strLOB_NM = .PivotItems(y).Name
End If
Next y
'create report and create on New tab named via strLOB_NM
' FormatAuditIssueTables Sheets("Pivot Table"), strLOB_NM

Sheets("Pivot Table").Select

Next x
End With
End Sub

Thank you so much!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating worksheet reports from a pivot table Donna Excel Worksheet Functions 1 August 17th 09 01:55 AM
Pivot Table Reports Rich Mogy Excel Discussion (Misc queries) 2 April 7th 07 06:41 PM
Pivot table reports cannot overlap another pivot table Jean Excel Programming 1 April 6th 05 04:21 PM
Problem with Pivot table reports Shanmugavel Excel Programming 2 December 13th 03 04:27 PM
MS Excel - How can I summarize a table? Will Pivot Table Reports do this for me? hugh jass Excel Programming 4 September 11th 03 12:02 AM


All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"