projects

Hi everyone, I've spent two days using my Google-fu trying to find an answer, but I'm stumped. I have a spreadsheet that I'm using to monitor the progress of a number of projects, sort of Gantt chart-style. The projects are listed down the rows and the months of the year are the columns...

I have a large spreadsheet which is a massive list of projects. The projects are listed by row within a tab named "Projects". Each project generally consists of about 15 fields The fields, by column, are things like address, status, name, Dollars etc ... I want to create a Button that selects...

Hello Everyone, Really need an assist on this. I am building a workflow management tool tracking availability and workload of several workers across many projects. I need to build a table, without vba if at all possible, that automatically populates comparing to separate copies of a report and...

Using PowerPivot I am struggling to create a measure to do the following: I have a bunch of projects that people book time to. Hours are booked to either capex or opex tasks. I can create measures to compare time booked to capex or opex. What I would like to do is: Filter out all the...

I have monthly reports for projects that tell me how much has been spent on a project to the end of the month. I have 12 tables, one for each month with a list of projects and an amount. Each month as projects start and finish the list of projects will change and they may not be in the same...

I'm a bit out of my element here and have written a script that will bring in some new project numbers and it puts those on the bottom of Column B. Column A contains formulas (Column A is an error check), Column B is the list of project numbers, Column C through AC are formulas based off of the...

Hi , I am planning to create a dashboard which will help executives look at how many projects we can start with respect to resources available / freed up. I have a list of projects with Resources required and i also have the number of resources required for each projects. Can someone please...

We have contracts that have multiple projects. Each project stands alone for payment but all projects must be completed before the contract is considered complete. I'm making a pivot table and pivot chart. My boss wants to see projects that are 95% or more complete. I added a formula...

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...

Hello, I've been searching the internet for a solution, but not sure one exists: I want to create a dropdown menu which allows the user to select 'red', 'amber', and 'green' and changes the colour of that cell as appropriate. This part I have achieved successfully. However I would now also...

I am trying to develop a way of tracking projects for my team. Ideally, this would be a shared workbook, that would allow team members to enter/update projects and also allow for management views. I was thinking I could use a form (?) for the team members and then make this form feed a...