LinkBack URL
About LinkBacks
Hi all,
I've got a calendar that I would like to create a few macros for. Yes I want to do this in VBA and no I do not want to use MS Outlook or anything else but code. Here is why:
Every month at work we receive a certain amount of tasks to complete with only 21 days to do them. My manager typically makes a calendar and types how many tasks each of us have to complete each day and sends it out to us to use as a reference to make sure we stay on track. The problem is she hasn't figured out how to count and generally messes things up and we all have to pay for it in the end.
I've got a blank calendar and when "June 2012" is typed into D5 and D7, I want it figure out which day the 1st of June falls on (In this case it will be Friday) and label the square for that day with a 1, then fill in the days for all 30 days in June on the calendar. This will be completed with the macro after clicking the button labeled "Create New Calendar" (see attachment)
Once that code is programmed, a start date (typed into D9) will tell the program which day to start on, and the quantity entered into D11 will output into the bottom of the square for that day, minus 3. Lets say the number entered into D11 is 50, the start date's square would contain the number 47 (see attachment M14). Since we only work Monday through Friday, 21 days allows us to complete 3 tasks per day; however, 4 tasks must be completed 2 of the 21 days in order to be finished on time.
Anysquares without a day in them will be colored gray and if the last day of the month leaves a blank row beneath it, deleted the squares for those days.
In all honesty, I am hoping much of this can be done with a few loops, and I don't know if I'm asking too much, so if I am please tell me! Thanks for your help on this work in progress even if you can only help with one portion of it that will be helpful to me!
Kelly
Register To Reply
Bookmarks