Excel and Pivot item counting

[Groom]

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

[Ecniv]

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?

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...