month calendar
Our boss asked us to fill a report every month where we set the time on
different projects (for billing purpose). He gave us a template where they are lines with the projects and columns with days. When a day is on the weekend, he must have grey background and no calculation (time total). As you can guess, the weekends changes every month, so every user copy the existing previous month, and takes 15 minutes changing the report, removing existing weekends and placing new ones. Would it be possible, by setting the name of the sheet (say 1/2003) to automatically fill this report to match the weekends of january 2003 ???? I'm new on Excel programming (I'm a Delphi programmer), so any code would greately be appreciated. Thanks in advance. BoB |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com