Macro help to reformat production data

[melan555]

Dear all,

Kindly help me on this. I have been working on a report which i needed to format in order to integrate with a pivot table easily. I have tried several times with a macro but didn't work out. I have attached the report herewith.

1st sheet has original data. 2nd sheet has the format i need. Production Plan.xlsx

The requirement is to get the plan quantities given for each date in horizontally for the month in vertically so i can easily get in to a Pivot table. I had manually copied style+del A2:A165 range 30 times( for each day) and down the cells and similarly copy quantity data in cell range 2:165 of each column(for each date) down the cells under a single quantity column.

Looking forward for your support.

[Bob Phillips]

Please Login or Register  to view this content.

[melan555]

Dear Bob,

It worked!!! it worked!!!!! You are my HERO and you saved my day.... thank you very very much.. this is very much appreciated