VBA to transpose values by matching column with Pivot Table (Dashboard)

[JackJon]

Dear Experts,
I'm pretty much a newbie on VBA.
I really need your expertise for below case:-

I need to transpose the values/TURNS from PivotTable1 to Dashboard sheet under column B by using macro.
Codes are already written but i'm facing an error on "REF". Is there something missing from my code?
Please review and kindly get back to me.
Thank you.

https://www.excelforum.com/excel-pr...ccumulated-values-based-on-live-database.html

 

[JackJon]

Hello Guys,
Please help on this request.
If you need any further clarification, do not hesitate to do so.
Thank you.

 

[JackJon]

Hi All,
Please assist.
Your help will be greatly appreciated.