VBA Novice Needs Help Manipulating a Pivot

HugoRune

New Member
Joined
Nov 12, 2009
Messages
29
Hi Guys,

Although I am becoming more savvie with Excel (2003) I am a complete novice when it comes to VBA.

What I am needing to do is have 2 worksheets, 1 with a pivot table and the other to display the data. Then when selecting a value in cell A1 on sheet 1(data) it changes the Page Field of the pivot table on sheet 2 to match the selection.

EG: Sheet1!A1 = "Team 1"
Sheet2 Pivot Table Page Field (Teams) = "Team 1"

Hope you can help chaps
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,119,291
Messages
5,577,223
Members
412,777
Latest member
jmulldome
Top