+ Reply to Thread
Results 1 to 1 of 1

Autopopulate schedule- by task / from milestone dates

  1. #1
    Registered User
    Join Date
    01-27-2020
    Location
    Liverpool UK
    MS-Off Ver
    Office 365
    Posts
    1

    Autopopulate schedule- by task / from milestone dates

    Hi all.

    Looking at this forum,there's clearly a lot of smart folk and I have a specific question -- I've looked into the other threads and they don't quite fit my needs at the minute as I'm looking at trying to build a sheet which has a level of project management which is a bit more wieldy for me specifically (I'm not a project manager but need something which can broadly serve as such)

    I'm trying to populate a schedule with tasks that need to be done in specific weeks. I don't need start / end dates in a project management style, just the ability to shift dates around as things ebb and flow, working backwards from specific key milestone dates.

    I've attached an example of the sheet. What I'd like to be able to do is add new task categories in column b and manually label the parent category -- I guess the challenge is if there are multiple tasks due under a task category in one specific week and how to handle that? (thoughts welcomed!)

    I'm not looking for conditional formatting or anything at this point or anything too fancy - just a nice simple way of adding tasks in a schedule, manually tweaking the time to completion from milestone dates and seeing it laid out in a schedule.

    I'm hoping someone here can help me? Much appreciated.

    thanks ever so much
    Attached Files Attached Files

+ 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. Milestone dates to calculate a revenue payment
    By bdlchicago in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2014, 11:24 AM
  2. Nested IF function to count days from milestone dates
    By glenpizz1978 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-26-2014, 10:16 AM
  3. Autopopulate Report with Schedule Worksheet Data
    By hoyasaxa215 in forum Excel General
    Replies: 5
    Last Post: 07-25-2014, 01:43 PM
  4. create daily schedule using master task schedule
    By DCO in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2012, 01:08 PM
  5. How can I populate milestone dates for more than one outcome excel
    By Bayebd24 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-21-2012, 12:31 PM
  6. Spreadsheet to schedule a task
    By dannycelluk in forum Excel General
    Replies: 6
    Last Post: 04-06-2012, 05:01 AM
  7. Schedule task without Login
    By macroplay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2006, 09:05 AM

Tags for this Thread

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