Does anyone have a template for using Excel as a simple Construct.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JLWCFM (JLWCFM_at_discussions.microsoft.com)
Date: 10/31/04 

Date: Sat, 30 Oct 2004 18:09:01 -0700

We prepare a summary for people who do not know/have Project. The schedule
is simply the task name with cells on the row shaded to indicate the weeks of
the project duration. I am looking for a simple way to enter a start/end
date and have the system calculate and shade the appropriate number of cells
on the row.

Relevant Pages

  • Re: Does anyone have a template for using Excel as a simple Construct.
    ... Lots of nested Ifs to check if not blank, is date, not too many columns, ... Private Sub Worksheet_Change ... > We prepare a summary for people who do not know/have Project. ... > is simply the task name with cells on the row shaded to indicate the weeks ...
    (microsoft.public.excel.programming)
  • Re: Is there an easy way to count when adjacent cells contain same data?
    ... merged cells, variable numbers etc. ... It copies the master schedule to each person's individual ... > I would like to flag when a double shift is created. ... All other sheets get their data from the Master sheet. ...
    (microsoft.public.excel.worksheet.functions)
  • Subject: how to calculate time in a payroll worksheet- Revisited
    ... My time sheet is set up like the brief example ... This sheet shows a schedule for each employee. ... I am not doing well at tying the previous examples into a working formula ... over a range of cells. ...
    (microsoft.public.excel.programming)
  • Re: Can Project perform global changes?
    ... changes made to all selected tasks ... Ctrl key down and select cells below. ... I have helped schedule a number of plant shutdowns with a lot of tasks and ... Project, such as assigning resources, updating code fields, etc. 2) Is ...
    (microsoft.public.project)
  • RE: autofill date times
    ... How can I make Excel autofill 365 days in a year with 24 hours in each day? ... I am working on creating a shift schedule for paramedics and firemen. ... I highlight these cells and use autofill to fill in the rest of the year ...
    (microsoft.public.excel.misc)