[SOLUTION HELP]: Copy data from cell and pivot table into new table format.

[sasils]

Hello,

I need your help on EXCEL VBA solutions as per below requirements
1. Copy pivot table data in cell A9:A11 and C9:C11 in to sheet OUTPUT per example in sheet output.
2. Copy data from sheet INPUT cell G32,G36,G37,K32 (cut only first 2 digits),K33,K34,K35 (cut only first 3 digits),K36,K37,K38 (cut only first 3 digits)M32 (cut only first 2 digits),M33,M34,M35 (cut only first 3 digits), N31
3. Arrange it such a way that it matches the OUTPUT sheet layout.

Thank you so much for your support here. Attached file is for reference.

Regards

 

[sasils]

Anyone? thanks