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.

Hi,

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

Can someone please advise with my problem?

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

Hi,

Is anyone able to aid me with my query.

Thanks,

Mufeed