Results 1 to 3 of 3

Multiple project arms with different anchor dates. Best way to solve?

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2019
    Location
    High Point, NC
    MS-Off Ver
    2016
    Posts
    2

    Multiple project arms with different anchor dates. Best way to solve?

    Hello! We use excel to do project planning. Within a single project, we have multiple arms that follow the same event intervals but oriented to different anchor dates. Example attached

    Currently, we create a new schedule for every Project Arm in order to project the proper event dates, but I'm sure there is a more efficient way wherein the Project Schedule would be created once, the Anchor Date for each Project Arm would be entered, and the system would automatically produce the event schedule for that particular Project Arm by referencing the Project Schedule

    So, what's the best way to approach this problem? I've done VBA in the past but not really in connection to excel, and I'm not really sure that's even the best way to go about solving this. Any advice to get me in the right direction would be much much much appreciated.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by SamHPCTC; 09-24-2019 at 05:38 PM. Reason: Added attachment and simplified description

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: 08-11-2017, 03:10 AM
  2. Replies: 1
    Last Post: 06-12-2017, 09:20 PM
  3. [SOLVED] Project Dates - avoid blocked dates
    By pauldaddyadams in forum Excel General
    Replies: 12
    Last Post: 01-15-2016, 06:42 AM
  4. [SOLVED] Copy one cell and past to multiple black cells using a Dim anchor point
    By mariannehislop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2014, 09:55 AM
  5. [SOLVED] Function that concatenates multiple sub-project descriptions based on project code
    By markbpi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 06:49 PM
  6. Anchor Text to link to multiple websites
    By boyblue in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2007, 10:58 PM
  7. Calcualte APRs for ARMs and Balloon payment mortgages
    By Confused in Chicago in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-02-2005, 03: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