Hello,
I written a VBA routine to create a pivot table from data on another sheet. The routine works fine except that the "data" cells are count() instead of sum(). I've been searching for a long while and can find an any examples of someone changing what the data portion of the pivot table summarizes by.
Any ideas where to look? or a snippet would be even better!
-Pete
Games the old fashion way with Dice, Paper and Pencils!
I written a VBA routine to create a pivot table from data on another sheet. The routine works fine except that the "data" cells are count() instead of sum(). I've been searching for a long while and can find an any examples of someone changing what the data portion of the pivot table summarizes by.
Any ideas where to look? or a snippet would be even better!
-Pete
Games the old fashion way with Dice, Paper and Pencils!