Excel and Pivot item counting
Hi
I need some help with how to write a code.
In the pivot table I have:
Row:
Shos
Column
Brum
YYY
Tomot
JAMS
Some weeks, other items can show up in the column and can appear anywhere between the column items.
I need the number of items for each column items, to be shown in specific fields.
And the counting of the items should be after the name of the column items.
How should I write the code?
See the picture of how it looks now, need the amounts below example, Brum, etc...
http://img691.imageshack.us/img691/520/excelvalues.jpg
Thanks in advance.
Best Regards
Groom
Re: Excel and Pivot item counting
Quote:
I need the number of items for each column items, to be shown in specific fields.
And the counting of the items should be after the name of the column items.
Your grand total line?
Quote:
Some weeks, other items can show up in the column and can appear anywhere between the column items.
You have cells for those too?
I dont get what you are trying to do...
Copy n paste special values?
Find in a specific range the column title, then move to the right one (or down one) and copy n paste special values of the lowest cell in the pivot table...
Note the cells you are posting to <i>cannot</i> be on the same sheet as the pivot, since the pivot changes size depending on data...