Hi All,

Before I start, I would just like to thank you for reading my thread and I hope I can learn something from this, & I hope someone can help.

Basically I have a spreadsheet, that a number of people use to fill out the work we have and the allocation they have at any given week.

The problem is this data is not in a format a Pivot Table can use, so I programmed some basic code to convert these inputs into Raw Data for the Pivot Table.

This was all well and good, until the number of projects etc has grown, and now my rubbish IF loop VBA code is struggling and it is taking a very long time to load.

Therefore I need help on how I can speed this up, I have attached a small sample of the spreadsheet I use, and included a Raw Data tab that my code produces automatically.

All the raw data tab requires are the first 5 weeks of any given resource, I havent included my code, as I believe it is rubbish and needs an overhaul.

Anyone have any good suggestions or code on how this can be completed quickly? Thanks Again!

The sample file attachment - Test.xlsx

Regards,

Boz