Generating Calender Automatically

[Mei]

Hi,

I've programmed access using VBA before but not excel. I'm lost and
duno where to start. This is what I intend to do:

To program a system to let users know if a resource is being book. So I
would have current month in 1 row, and the day of the month in another
row something like this


May (current month)
1 2 3 4 5 6 7 8..... 31 (days of
the month)
sun sat mon tue wed (week of the day)
Resource 1
Resource 2
Resource 3 ....

I want the excel file to dynamically generate a sheet (calender with
the resource) for each month and delete the old sheet. How feasible is
this? Should I use macro? VBA? or combination of both? Many thanks for
any advice.

 

[Mei]

Hi,

I want to add a macro such that for a month with 30 days select 30
columns, 31 days select 31 days, feb select 28/29 columns depending if
its a leap year..any advice on how to do it? Thanks for any advice!