+ Reply to Thread
Results 1 to 5 of 5

Project tracker automation

  1. #1
    Registered User
    Join Date
    07-07-2015
    Location
    England
    MS-Off Ver
    MS Office 2010
    Posts
    69

    Project tracker automation

    Hi,

    I am currently working on making it easier to track projects and calculating the days each project goes over the agree time. I would like to produce a 4 box model but unsure of the best way to do this. I have set up forecast date and completion dates already but would like this in a graphical format to see timelines etc. I would like to find out the best way to measure the # of total projects on time and # total projects delayed etc. There are different stages of the project but for some projects not all stages are needed. I would like to make the spreadsheet more visible so if selecting one project the relevant columns appear.

    At the moment, as team members are filling it in it can be vulnerable to human error i.e. wrong format of date and sometimes somehow they misspell their name even though I have a data validation list. I would like to make it so when entering a new project it states their names date format etc so it doesn't play havoc with the spreadsheet. Maybe like a button that brings up a pop box with blanks to fill in specific things like a form. Not sure how I would do this.

    I need some help with this to make it sleek. I have attached the sheet.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,082

    Re: Project tracker automation

    comment deleted
    Last edited by protonLeah; 08-09-2017 at 06:11 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-07-2015
    Location
    England
    MS-Off Ver
    MS Office 2010
    Posts
    69

    Re: Project tracker automation

    Hi,

    Apologies. I was informed that it would be best to post the thread here.

    Can someone please advise with my problem?

  4. #4
    Registered User
    Join Date
    07-07-2015
    Location
    England
    MS-Off Ver
    MS Office 2010
    Posts
    69

    Re: Project tracker automation

    I've marked that thread as solved now and moved the query onto here. I've had some go at the spreadsheet with help. Please see attached.

    The steps I would like is to
    1) ask them to enter the project name,
    2) ask what stage is it; feasibility, evaluation, final etc
    3) then from there enter the relevant dates, Latest issue, author (from a list) and so on. not sure if you can produce a data validation list in vba.

    I would also like the projects to be in alphabetical order too

    Essentially I would like to cells to be locked and have people not have to mess about with it

    Thanks
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-07-2015
    Location
    England
    MS-Off Ver
    MS Office 2010
    Posts
    69

    Re: Project tracker automation

    Hi,

    Is anyone able to aid me with my query.

    Thanks,

    Mufeed

+ 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. Creating a project tracker
    By sorensjp in forum Excel General
    Replies: 8
    Last Post: 01-17-2017, 05:45 AM
  2. [SOLVED] Project supplies tracker
    By makinmomb in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-12-2014, 12:55 PM
  3. Task \Project Tracker = determine output time based on variable inputs
    By Journeyman3000 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-10-2013, 04:37 PM
  4. [SOLVED] Project Timeline Tracker
    By AnnaG87 in forum Excel General
    Replies: 1
    Last Post: 04-30-2013, 11:39 PM
  5. Replies: 0
    Last Post: 06-14-2012, 02:49 PM
  6. Attendance Tracker Automation in Excel
    By Tanveer Genisys in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2010, 01:32 AM
  7. Need help with excel Project tracker Macro
    By david.snellen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2010, 09:47 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