Hi,
Getting really desperate and need some serious help.
I am busy trying to write a macro that will enable me to input a month and year i.e aug 2006, it then sets up the spreadsheet as follows..
Tue
Thur
Fri
Sun
Tue
Thur
Fri
Sun
Tue
Thur
Fri
Sun
Tue
Thur
Fri
Sun
Tue
Thur
Fri
Sun
What I am trying to do it is populate the cells next to the days with the date i.e.
Tue 5/09
Thur 7/09
Fri 8/09
Sun 10/09
Tue 12/09
Thur 14/09
Fri 15/09
Sun 17/09
etc.
Is this possible??
Best regards,
Ken
Getting really desperate and need some serious help.
I am busy trying to write a macro that will enable me to input a month and year i.e aug 2006, it then sets up the spreadsheet as follows..
Tue
Thur
Fri
Sun
Tue
Thur
Fri
Sun
Tue
Thur
Fri
Sun
Tue
Thur
Fri
Sun
Tue
Thur
Fri
Sun
What I am trying to do it is populate the cells next to the days with the date i.e.
Tue 5/09
Thur 7/09
Fri 8/09
Sun 10/09
Tue 12/09
Thur 14/09
Fri 15/09
Sun 17/09
etc.
Is this possible??
Best regards,
Ken