PIVOT - refresh pivot based on Field / item
 

Hiii,

I have a pivot table with 4 rowitems, 2column headings, 2 datas

row item 1 North
row item 2 South
row item 3 East
row item 4 West

col heading 1 Jul09 revenue
col heading 2 aug09 revenue

Row field name = "Region"
contents = North, South, East & West

the table is placed in the range of a7 : a200

I allow to enter in b2 as North
and allow to enter in b3 as Delhi
Now i want VB code to filter fields/items North & Delhi as above

Eddy Stan

PIVOT - refresh pivot based on Field / item
 

you can use the worhsheet Data/Filter/AutoFilter for this

"Eddy Stan" wrote:

Hiii,

I have a pivot table with 4 rowitems, 2column headings, 2 datas

row item 1 North
row item 2 South
row item 3 East
row item 4 West

col heading 1 Jul09 revenue
col heading 2 aug09 revenue

Row field name = "Region"
contents = North, South, East & West

the table is placed in the range of a7 : a200

I allow to enter in b2 as North
and allow to enter in b3 as Delhi
Now i want VB code to filter fields/items North & Delhi as above

Eddy Stan