transposing data via a VBA macro

Hi All,

Going to try and explain this the best way I can.

The attached sheet has data in sheet1 which needs to be transposed into sheet2 format (final outcome).
A VBA macro the macro running the rest of the work is not in the same worksheet as the data sheets are created each day and it is required that the macros are not sent with the final output to the user. This part I can do and the read of the text file is working fine (all be it a bit clunky due to lack of experience, but it works )

The following needs to be considered.
1) There may not be data for a weekday but the script needs to deal with that and continue.
2) The sheet2 needs to be in week order and date order.

Any help would be much appreciated.

Regards

stubyh

Try the attached.

Please Login or Register  to view this content.

as an option

Please Login or Register  to view this content.

to jindon and nilem

Many thanks for your responce both work excelent.

Regards

Stubyh

Hi, sorry to mark this as unsolved but I need to ask further questions.

The original code from jindon is the one I am using, however I cant get it to go passed the 52 weeks, the sheet now contains two years worth of data and will continue to grow as the years progress. How do I make it so that it goes past the 52 weeks of the first year this case 2011 and then into 2012 data.

any help would be apreciated

regards

stubyh

Try this one.

Please Login or Register  to view this content.

jindon

many thanks for the quick responce,

regards

stubyh