Sleeper: Problem Pivot table &VBA

[frade]

Hello! :yes

I would like to create 2 pivot tables using VBA (destination in two differents sheets..) and, if possible, with the average of the results (in place of "sum
of the results") What can I do? do you have an idea?

Please have a look at my code (sheet2) to understand what kind
of table I would like to create.


Thanks a lot for your help! :hi:

Fran?ois

[Norie]

Francois

Neither of the codes in your attachment work, neither do the buttons on the sheet.

[frade]

Hello Norie,

Now, It's OK for this topic.

Thanks