Results 1 to 6 of 6

Creating a auto fill schedule

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2017
    Location
    KITCHENER
    MS-Off Ver
    2016
    Posts
    3

    Creating a auto fill schedule

    Hello all, this is my first thread so excuse my thread ethics....still learning

    I am looking for an easier way to schedule construction projects.
    Each project is composed of the following

    Design-2 days
    Drawings-5 days
    Material Takeoff- 1 day
    Production- 10 days
    Delivery- set date provided by client

    Typically I fill in the delivery date on a gantt char, and work backwards for the preceding items.
    Is there a way to select the delivery dates and have the preceding date automatically fill in based on duration parameters I set ?

    In actuality there are 30+ jobs, and most durations take months not days, so manually filling in the gantt chart is a pain.

    I have been playing around with conditional formatting but to not understand enough to make it all function.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Weekly Employee Schedule auto fill day info
    By timmiller420 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-12-2016, 06:43 PM
  2. Replies: 1
    Last Post: 03-14-2016, 07:25 AM
  3. Replies: 1
    Last Post: 11-13-2012, 06:48 AM
  4. Auto Fill the Schedule based on data
    By leo73pk in forum Excel General
    Replies: 1
    Last Post: 12-03-2010, 02:39 AM
  5. Creating Schedule with specific Dates.. auto?
    By Tekovro in forum Excel General
    Replies: 4
    Last Post: 12-14-2009, 04:32 PM
  6. How to Auto fill dates on a schedule
    By cardingtr in forum Excel General
    Replies: 3
    Last Post: 09-23-2005, 02:05 AM
  7. Creating an auto fill or drop down
    By Steve in forum Excel General
    Replies: 2
    Last Post: 07-06-2005, 08:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1