+ Reply to Thread
Results 1 to 2 of 2

Change Start dates upon duration days change in Project timeline calculation.

  1. #1
    Forum Contributor
    Join Date
    09-11-2008
    Location
    uk
    MS-Off Ver
    2010; 2016
    Posts
    400

    Change Start dates upon duration days change in Project timeline calculation.

    All,
    Need your expertise once again!!!
    I have a worksheet with three separate sections: Current, Amended and Final.
    These represent a continuous improvement project I am investigating for my firm.
    In the attached dummy file, columns A, I and Q show will show the step processes to develop a widget and the number of steps will continuously alter,
    Each process step has a start date and an estimated duration. (Columns B:C, K:L, and R:S respectively). The estimated Final date is calculated by formula in the similar labelled columns.
    As I have quite a few worksheet changes, what I really want are macro’s to auto-increment and override the existing worksheet changes IF the associated button in columns i:k are pressed….to produce a continuous range where each start day is the same as the previous processes steps finish date.
    In other words, if I change any duration time (for example) c22 to 33 days duration, then the remainder of column B will adjust incrementally.
    I cannot seem to get this right, so seek your help!!
    Thanks for looking.

    Skyping. Please see dummy file for perhaps a clearer explanation!!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-11-2008
    Location
    uk
    MS-Off Ver
    2010; 2016
    Posts
    400

    Re: Change Start dates upon duration days change in Project timeline calculation.

    I seem to have found a method (its slow, BUT WORKS!!!)

    See below.....any advice to try and speed it up would be greatly appreciated!!!

    HTML Code: 

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 11-12-2012, 04:03 PM
  2. Change dates to UK format in the first 12 days of the month
    By portucale in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-21-2012, 07:33 AM
  3. Replies: 0
    Last Post: 09-20-2012, 12:05 PM
  4. Project timeline calculation
    By COGICPENNY in forum Excel General
    Replies: 5
    Last Post: 07-04-2012, 03:33 PM
  5. Replies: 4
    Last Post: 02-24-2012, 11:06 AM

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