Pivot table Programming

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have 2 Worksheet in my Excel report. On First Work Sheet (Sheet1)
I have list box fill up with Date values..On Work Sheet 2 I have Pivot Table.
Now I want to assign some selection Filter on Page field in Pivot table..

How Can I assign Selected value in list box ( on Sheet1) to Pivot table field
on ( Sheet2) for example..

List box : 10/1/2004,10/2/2004...etc
Now I will select in list box : 10/1/2004, This value I want to assing to
one field in Pivot table.. Let say EnterDt=10/1/2004 ( All the date in list
box is part of my dimensions)

Thanks
 
You must log in or register to reply here.

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

How I can set dynamic pivot table ONLY when I have enough data point 1
modified pivot table using a macro 2
linking pivot table selections 2
Pivot table code question 2
Unable to Group in Pivot Table 1
Pivot table multiple filters 2
Automatically Update a Pivot Table Field Used as Column / Row 1
Playing back a Pivot Table macros 2

Back
Top