Hi all.
Excel noobie here. I need your help please.
I am wanting to create a excel, which displays one worksheet for each month of the year - January to December.
And in each worksheet, for example January, should automatically display (just like a calendar) every day of this month.
I would like to have a blank cell under each day, which I can add a value of 0 or 1 and have a weekly total. I would also like to have a monthly total displayed somewhere.
I have been doing some reading and I believe Macros will be needed for this project.
I am an Excel beginner, but willing to learn if someone can guide/instruct me, so that I can get started please.
Thank you.
Excel noobie here. I need your help please.
I am wanting to create a excel, which displays one worksheet for each month of the year - January to December.
And in each worksheet, for example January, should automatically display (just like a calendar) every day of this month.
I would like to have a blank cell under each day, which I can add a value of 0 or 1 and have a weekly total. I would also like to have a monthly total displayed somewhere.
I have been doing some reading and I believe Macros will be needed for this project.
I am an Excel beginner, but willing to learn if someone can guide/instruct me, so that I can get started please.
Thank you.
