project management

I've created a Critical Path for a project, shown in the image. Columns C & D are the Start and End Dates respectively, and I'm keen for the subsequent cells (here F5:AP44) to automatically fill with colour (say, light blue) as the Start & End Dates are updated. I've seen it done in a previous...

Hello everyone, I am working on a project employee capacity-sheet, with several projects and the capacity for each month. I want the percentages (D2:M4) shifted automatically when I, let's say, change the end date to 2023-05. How do I achieve this? Thank you so much in advance! :-)...

Hello, I am using vba in windows. I have a excel project. I need to have a list of projects, the status of the project color codes the row. Data is sorted by macro that sorts data by its color. I want to have page where all the projects are listed and then one sheet for each status, which are...

Hi All, I'm new in the forum and was browsing through it and was not able to find the answer, perhaps if you know the thread you can direct me to it. Mainly I'm looking for a way on excel to unify on one tab the roles on another tab with multiple projects. Let's say the consolidated staff...

Hello there, I am attempting to create a project planning and management tool for our workplace. What this entails is obtaining "work hours", an "in date", and an "out date" for each project. The program will divide the number of working hours over each business day that a project may be worked...

Suuuuper fresh to VBA here. I've got a table that has many grouped rows all individually under their main banner row that I use for project management that has multiple rounds per project (hence grouped & banner rows). I am trying to add a "Add New Audit" button that adds a new chunk of rows...

Not sure if this would be in VBA or not but here is the situation. On a worksheet I have titled "Job Numbers" I have in column c different job numbers going down by row. In column A I have bid hours for the job filled out. In column B I have used hours for the job that will need to be filled in...

Hello! I am trying to create a chart to represent block schedules by date. So far I set up my table and chart as you can see in the image in link ( https://photos.app.goo.gl/KKYhpmq6LVXaVtAP7 ). I am stuck with the following: If a date has more than one block (overlapping or not), can you...

Hello all, I am working with a table containing a list ofprojects, project start dates, project end dates and project costs per day. Theprojects can last any number of days and end in different months than theystart (eg Project 2). This table is shown below in range A1:D5: I want to...

Hi. I have a VLOOKUP-problem I hope you guys can help me with: The input: 1) I have several worksheets in a workbook. Each worksheet is representing a project with financial figures. There is about 100 projects, so there are about 100 worksheets in the workbook. The names of the worksheets are...

INTRODUCTION This is an attempt at creating an excel database for work that will allow employees to identify who is handling a particular task for a given client. Excel is pretty much the only option since most employees are familiar with the application and almost no one knows how to use MS...

Hello everyone. I posted this question on another Excel forum last week and no one has responded. :( So here goes nothing... Here at work as a Project Manager, I have been working on redesigning a spreadsheet that tracks the corporation's current projects individually, and displays each...

I need to chart a schedule that has date across x axis and the tasks along the y axis. The task for each project should look like a little bar along the timeline with each project being a different color code. I have been able to figure this out for a single project timeline but not how to...

I have a project network spreadsheet shown below and in column BT I need to identify each non-critical path task (value in column BS is "N") that has a critical path task (value in column BS is "Y") as one of it's immediate predecessors. Predecessor tasks are listed with commas separating them...

Hi Ladies and Gents, I plan to use the critical path method (CPM) technique to manage a project I will begin working on soon. I therefore set up an Excel sheet with the following columns: Column A: Activity Code (different activities represented by different letters) B: Description of Activity...

Hi Ladies and Gents, I plan to use the critical path method (CPM) technique to manage a project I will begin working on soon. I therefore set up an Excel sheet with the following columns: Column A: Activity Code (different activities represented by different letters) B: Description of Activity...

I have read lots of information regarding timelines,stacked bar charts, gannt charts, but have not been succesful in displaying information I require. I have a certain number of projects on the go at once, all at different stages. I want to be able to display all these stages at once for each...

In a project i am compiling i need to work accurately with times to calculate the work progress of the people in the workshop thus....here goes.... I have in work book #1 (7) sheets mon to fri + complete week + a sheet where all job numbers are collected. From monday to friday the workmen log...