Fetching Correct Respective Values from Pivot Table and pasting it into another Excelsheet

Hi Every one!!

Need your help !


I have an data in pivot table (attached file PivotData) and i have another Excel template sheet
were in i want to copy & paste values from this pivot table to another(Excel Template)'s under respective headings.

but only thing matters as some of time according to Shuffling in data some times
row B either in Std:5 or Std:6 do not appear and so only can not directly set reference in Macro to directly copy paste data from available cells to below table's respective Cells.

I want data from Heading A,B and C if present then automatically copy the values from it's adjacent rows and paste it in respective manner such as which ever data is available it should copy and paste into that another excel sheet template and which row's value is NA their it should be Zero..

hope you understand what is required!

Hi DILIPandey, Please find the attached sample workbook (Uploaded now), thank you very mcuh for your quick response!

regards,
MichaelBlue