Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Generating Calender Automatically
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 ------------------------------------------------------------------------ Mei's Profile: http://www.excelforum.com/member.php...o&userid=23792 View this thread: http://www.excelforum.com/showthread...hreadid=374467 |
#2
|
|||
|
|||
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! -- Mei ------------------------------------------------------------------------ Mei's Profile: http://www.excelforum.com/member.php...o&userid=23792 View this thread: http://www.excelforum.com/showthread...hreadid=374467 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
Automatically update from source when file opens | Excel Discussion (Misc queries) | |||
Automatically Populating Worksheet from Collected Input for Pricelist | Excel Worksheet Functions | |||
Automatically Populating Worksheet from Collected Input for Pricelist | Excel Worksheet Functions | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |