Trouble with Load Macro

[mohorter]

Please see the included spreadsheet

I have some macros attached to it and they work except for my load button. It loads the left side of the input page correctly, but not the right hand side that has the dates on it.
The macro that i need help with is the Date_Load.
It loads only the first day of the week and includes the same data for each day for that week

I have only coded a small bit to try to get it to work, but no luck so far.

Save button works perfectly
When i save the data it saves correctly on both pages

Please Login or Register  to view this content.

Any help would be greatly appreciated

Thanks
Adam

[torachan]

remove 'Application.Transpose' from each line

[mohorter]

Perfect, many thanks!!!

[mohorter]

I have another question for you. I have all of this code on one line and it wont accept it since it is so long. Is there any way i can make it shorter to make this work?? Or a different variant that will have the same output when saving?

Thanks
Adam

Please Login or Register  to view this content.

[mohorter]

Here is the file again

[torachan]

the question is "what are you doing with it after you have tried to 'group it' ?????

[TMS]

Maybe:

Please Login or Register  to view this content.