Macro Request for Copy cell value from Pivot to default template

[ganeshinscribe]

Hi All,

I have lot of customer data information in sheet1, Sheet2 as Pivot for requested customer and its source from sheet1. I need to copy this pivot table data value to our chart template sheet3.

Please find attached Excel sheet which we processed manually.

Please review and help to automate this process in Excel.

Thanks / Ganesh

[:) Sixthsense :)]

Please check whether the Sheet Names mentioned in your description is matching with your file?

[ganeshinscribe]

Hi Forum Guru,

Sorry for the confusion,
Here i referred description Sheet 1 = "DATA" Sheet 2 = "PIVOT" and Sheet 3 = "DATACORP1", "DATACORP2" and "DATACORP3"


Please let me know if you have any clarifications.

Thanks / Ganesh

[:) Sixthsense :)]

In Every A1 Cell of Sheet 3

=SUBSTITUTE(UPPER(REPLACE(B1,1,FIND("]",B1),"")),"DATA","")

In Every B1 Cell of Sheet 3

=CELL("filename",$A$1)

In B3 Cell

=IF(A3="","",IFERROR(GETPIVOTDATA("Std Qty Shipped",PIVOT!$A$5,"Group Name",$A$1,"Prdt Category",$A3,"Fscl Week Num",B$2),0))

Drag it down and right...

Refer the attached file for details