matching the column with a value from pivot table

Hello,

i have a challenging issue i cant handle
at some place at my macro, im making a pivot table that counts an average value of all sales from every week that a product was sold.

What i want to do is that macro would automatically puts an average value in newly build column (AVERAGE) just as You can see in the attached workbook
What i cant figure out is how the macro would find that in column A is "product1" and put an average of all of the weeks in the new column (in all of the rows which are product1)
and then do the same thing with the average of product 2.


Best Regards
mumsys

Hi thanks

but that's not what i meant. I already have a pivot table (its in the attached workbook). All i need is a macro that would copy the average value of product1 to all of the rows where "product1" is in the column A in the table on the left. The column AVERAGE is an example how it supposed to look and what im trying to achieve hope its clear enough now

Best Regards

the thing is, that the table where the data should go may be in another workbook. So i need macro to copy the values from pivot table to matching places in the table.
Product 1 - (average of all weeks sales of product1 f.e 10)
Product 1 - 10
product 1 - 10
product 2 (average of all weeks sales of product2 f.e 20)
product 2 - 20 etc

Hi, i still can't figure out how to pursue with my project

In attached workbook i'm showing what i have (sheet1) and what should be the output (sheet2)
I want macro to copy an average value from pivot and put in certain rows that match.

Thank You in advance for help

maybe formula (in E2)

Formula:

Please Login or Register  to view this content.

its because this operation is one of many operations that i'm doing with raw data by the macro. and i need this to happen :P

Thanks nilem, that would work, but i'm thinking how it would fit if the table has randomly big amount of values.