Hi,

this is my first post here, though I'm sure I used this forum dozens of times.
I'm having trouble defining the data fields in a pivot table using cells reference in another sheet. what I want to be able to do is have one cell for function (count, average, sum, etc.), and one more for the data used for the values or what it's called , and make the switching of values in the pivot table as dynamic as possible.

I'm grateful to whatever assistance you guys can provide. if you can supply with a simplified example it would be great.

thanks,

Samuel.