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