DaveJenkins
New Member
Hi All,
I need some advice / pointing in the right direction.
In the file that I have attached, I have shown the data I receive, unfortunately they wont/cant change the format they have it in. However, I require the data tranposing and then dates for that week filling in based on the week commencing date at the top. I have shown this in the file.
I think what I want is possible, however, I dont know whether it would be done in VBA or some advanced formula.
I thought that I could do something with a pivot table but it appears that the pivot hates the original format!
Any advice, tips or code would be very appreciated.
Regards,
Dave
I need some advice / pointing in the right direction.
In the file that I have attached, I have shown the data I receive, unfortunately they wont/cant change the format they have it in. However, I require the data tranposing and then dates for that week filling in based on the week commencing date at the top. I have shown this in the file.
I think what I want is possible, however, I dont know whether it would be done in VBA or some advanced formula.
I thought that I could do something with a pivot table but it appears that the pivot hates the original format!
Any advice, tips or code would be very appreciated.
Regards,
Dave