Tag Archives: timesheet

Downloadable content Excel Projects

Developers Diary: An Excel Timesheet – The Basics

Ok, so I’ve started.  The file is attached here.

There’s quite a lot to talk about but I’m feeling a bit poorly today and not looking at going too much into depth.  Have a look around the file and I’ll post again about what I’ve done so far.  If there’s anything you’d like to suggest or anything that doesn’t look quite right do let me know.

Interesting things to look out for:-

  • Added right-click code on the timesheet page to block highlight days as annual leave or sickness.
  • Some pretty cool stuff going on with conditional formatting using named ranges on the timesheet page.
  • Started work on a setup page which will define how the sheet is used.

More to come soon when I feel better… :-(