project management

  1. H

    Macro for Auto Summing Values Identified by a Job #

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

    Schedule chart help

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

    Cost per month of multiple concurrent, intra-month projects?

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

    VLOOKUP Several sheets VBA

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

    Project Management - Identifying Employees assigned to a given task and client

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

    Automatically paste-link row in one sheet to a new row in another sheet with proper increments

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

    Chart a Production Schedule for Multiple Projects

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

    Identifying tasks based on the value of preceding tasksede them

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

    Project Mgmt: Converting Earliest and Latest Start, Finish Times and Slack into Actual Dates

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

    Project Mgmt: Converting Earliest and Latest Start, Finish Times and Slack into Actual Dates

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

    Timelines/stacked bar charts

    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...
  12. WERNER SLABBERT

    I have need of some know how...

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top