project

  1. A

    Need template for tracking project tasks

    Help me!!:confused: I have been searching for a template I can use to give me a starting point to create a project tracking document. I need to track several tasks that will have moving dates and be able to have cells change colors for priority, when dates are behind or on target, etc.. I'm...
  2. T

    Automatically populate a table

    Hi All, I have to populate a 3x4 table that is a list of our corporate projects. The projects belong to only one Division and Tier at a time. Projects progress from Tier 3 to 2 to 1. The data is sorted like this: <tbody> Proj_Name Tier Division Project A 3 Operations Project B...
  3. B

    Excel 2010 vs 2000 - Too Many Formats

    I've spent the last three months working on this project and am getting down to the short strokes. I asked my boss to take a look at what I have today and he got an error message that there are too many formats. I found out that while I have been creating this with Excel 2010 most others in...
  4. K

    Calculating % of Project Complete

    I have a list of 10 tasks in column A. Each of these 10 tasks is allocated varying percentages adding upto 100% of a project (column B). Ie. Task 1 represents 3% of the total project, task 2 represents 50% of the total project, etc. In column C is the % complete or each task - for example...
  5. D

    VBA to update/reformat cells on summary sheet when another sheet changes

    Hi there, I have a workbook that tracks projects by project# (CIR). A button runs a VBA module for NewProjects that prompts for a new (unique number) CIR, copies and pastes a new row into the "Project Summary" sheet, and copies a project details sheet from a template sheet and names it as CIR...
  6. K

    Stuck on creating formula with conditional formatting

    Hi! So in my 8th hour of trying to figure this out I've decided to bring in reinforcement ;-) I'm not even sure if the thing I'm trying to do is possible, so I'm hoping you can help me out! So what it is, is the following. I'm creating an hour log that also allows me to divide my day up in...
  7. X

    Sorting multi-level data in a table

    Hey guys, hoping I can figure out if this is possible to do. So basically I'm constructing a sort of project manager buy breaking down the steps. The below table is an example of what I am trying to achieve. <tbody> Priority Project Step #1 Step #2 Step #3 2 Education >> Reading >> Think...
  8. D

    Show summary data in a floating window from a row cells with content

    I would like to have a button on each row (or active row function) to show summary data for that row. The row is for products used in a project. It is very long so you would need to zoom out quite far to see it. I don't want to have a pivot table on a separate page. Because, as you go through...
  9. B

    Project Tracker

    Hello all, I am searching through the templates for a project tracker. One that will track customer releases by date along with sales orders and corresponding purchase orders to suppliers. Calculate released quantities against the estimated beginning quantity to know how much remains...
  10. D

    Can't find project or library

    Whenever I enter anything into a cell, a vba window appears saying can't find project library. I press ok then another window appears with a checkbox highlighted which says there are missing microsoft windows common controls. What do i need to do to get rid of this?
  11. R

    Visualizing relationship of similar tasks across many different Projects

    I have a schedule of Project level activities that encompasses tasks spanning multiple separate projects. Each Project is individually implemented at a different business location around the globe. However, any individual location may be impacted by the schedule of more than one project in the...
  12. D

    Create a row in a sheet if a column has a value but then consolidate all sheet's in to a master

    Hi All, I struggling to consolidate a number of sheets in to one Master sheet. I've a raw data sheet where a row indicates a project, each project has a spend amount in various quarters of the financial year I've then separate sheets that are then populated when a column has a value greater...
  13. D

    VBE Codes from excel 2007 to excel 2016

    Hello guys, I have this project and its VBE codes was from excel 2007. So I am trying to copy the codes to Visual basic and also create the same as my project but this time in excel version 2016 just to make it enhanced. Is it possible that it will work successfully? Really appreciated your...
  14. B

    Why are some macros available to assign to a button and others aren't

    I am trying to assign a button to a new macro. I tried to insert the macro into the workbook but it ended up in the project every time. I am unable to assign the button. I would appreciate it if anyone has a link or info or an article or something that I could educate myself with in terms of...
  15. G

    How to store a number of data sets in a sheet to be selected based on a project ref.

    Hello all, I am trying to create a spreadsheet template for a Failure modes & Effects analysis. I can create the template but what would be ideal is if the ranking values entered would adjust based on the project selected. For example If project 1 was selected all of the severity criteria...
  16. J

    Taking 9 columns and making them vertical with other data

    Hey everyone, I was working on a project in excel where I have 9 columns of dates. They each column represent a milestone in a project (it's kind of a scheduler). I want to make a pivot table that makes it so I can see all the milestone dates. Currently this is impossible as they are in 9...
  17. 1

    Construction Ranking Top Firms with Most Instances of Working Together

    I have an architect, HKS, and I'd like to see, when selecting their name in a splicer or drop down the top 10 other companies of other trades that they work with in a specific range of dates using a project name correlated with a project number to help delineate. IE Start Date - 12/1/2016 End...
  18. J

    Excel Gantt Chart

    Hello MrExcel'ers So I've been asked by my boss to put a project managers hat on, to build a gantt chart. I don't have Project Installed so I'm relying on good old excel I've provided an image view to show you want I'm after which in summary is to HIGHLIGHT (Column S:AA) based on a month...
  19. A

    Populating Cells using VBA based on Values from another sheet

    I am trying to figure out a tidy way to write the following scenario. Worksheet A Has a list that, from project to project will vary in the number of rows in it. Example of information in Worksheet A. Data to be used in Calendar Month column. <tbody> Calendar Month Start Date End Date...
  20. M

    How to insert 1 if value in a cell is different than previous cell and 2 if value is the same

    know the answer is easy, but I can't understand why it doesn't work. I have Column A: that contains a Project Number and Column B: that contains Group ID (of project). A Project can have multiple groups and I want to count and display the desired result (group #) in Column C: starting from one...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top