Pivot table Programming
 

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

Pivot table Programming
 

test
Op Tue, 5 Oct 2004 11:21:02 -0700 schreef Kris
:

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




--
Gemaakt met Opera's revolutionaire e-mailprogramma:
http://www.opera.com/m2/