PIVOT - refresh pivot based on Field / item

E

Eddy Stan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Multi Select List Box based on Advanced Filter 1
Selection based on partial input 1
Pivot table active dropdown 5
If C2 = East AND D2 < 20,000.00 then multiply D2 by 8% 4
Excel 2003 vba hiding totals for some pivot items and not others 3
Totals Only for Report 2
Totals for Report 2

Top