chandrashekarb
New Member
Hi,
How do extract data of particular pivot item using VBA. for ex. I need to extract data of
pvt_tbl.PivotFields("Priority").PivotItems(1).Visible in the same worksheet. Thanks!
With pvt_tbl
pvt_tbl.PivotFields("Priority").PivotItems(1).Visible = True
pvt_tbl.PivotFields("Priority").PivotItems(2).Visible = False
pvt_tbl.PivotFields("Priority").PivotItems(3).Visible = False
pvt_tbl.PivotFields("Priority").PivotItems(4).Visible = False
End With
How do extract data of particular pivot item using VBA. for ex. I need to extract data of
pvt_tbl.PivotFields("Priority").PivotItems(1).Visible in the same worksheet. Thanks!
With pvt_tbl
pvt_tbl.PivotFields("Priority").PivotItems(1).Visible = True
pvt_tbl.PivotFields("Priority").PivotItems(2).Visible = False
pvt_tbl.PivotFields("Priority").PivotItems(3).Visible = False
pvt_tbl.PivotFields("Priority").PivotItems(4).Visible = False
End With