hi all,

Is it possible to obtain all the values in a Page field list so that i can create a dropdown list with these?

My pivot table is called "PivotTable2" and the Page Field is Called "Date"

I want to be able to run a macro to get these dates and drop them into column c on a sheet called "Lists" any help is greatly appreciated!!