progress

  1. H

    Time used in-cell bar - today's date compared to due date

    Hi. I have a spreadsheet with the following layout: <tbody> H I J Due date Today 5 15/11/2019 =TODAY()<strike></strike> Progress bar needed 6 24/12/2019 =TODAY()<strike></strike> Progress bar needed <strike></strike> </tbody> <strike></strike> 1. What formula do I need in J5...
  2. H

    Add contributing %s to max 100% total

    Hi. I have a spreadsheet <tbody> D E 1 Question 1 90% 2 Q1 assessment criteria 1 20% 3 Q1 assessment criteria 2 30% 4 Q1 assessment criteria 2 40% </tbody> Under Question 1 there are three things users have to report on their progress with. They type in the % figure and...
  3. L

    calculating progress of Time or Date

    Hi I want to calculate the progress. I have Start and End date and also Start and End time. I want to find the progress as of today and time now. So I used conditional formatting --> new --> based on cell value -->bar (please see attached excel file). for date A2= Start date: 1/1/2019 C2= End...
  4. H

    Comparing figures against target formula

    Hi I need a forumula for the following. In columns going left to right I've got dates populated, one day per column. On each of the Mondays (or Tuesday of the week, if that week had a Bank Holiday Monday!) there are target values showing that are the values that should be achieved at those...
  5. S

    Lock progress chart to a specific cell

    Hi, I think this might be easy or just not possible. I am creating a training matrix for my company to drive competence and have started an excel document. The progress charts show progress and will help set targets. The problem I have is when I insert a new row, adjust size etc, all my...
  6. J

    How can I add a progress bar to a loop?

    Hi, I've never done anything before with progress bars. I have a macro which loops through a worksheet to last row and the data is used to update an external program. The problem is if there are a lot of rows (1000+) Then excel freezes up until finished. Is it possible to add a progress bar...
  7. C

    Indirect - Referencing tab

    Hi i am working on on a training matrix at work, there are 8 members of staff with a tab named after them. There are 58 odd tasks they need training on and have a measurement of out of 5 on the progress, if there progress is 3 or blow they still need training on that task. i have made a...
  8. H

    Help me with a 100% complete formula

    Hi. I have a stacked column chart and am setting up formulas to enable CF colouration of the chart columns. E F G H I 0 26 51 76 100 25 50 75 99 100 Beside the first row which will contribute to the chart (row 9, first cell is C9 where the user enters the % progress...
  9. E

    Add a new row to a table when a new sheet is created containing references to that sheet

    Hi, I have a Workbook which when users fill in a form, in creates a new sheet from a template and fills in some of the sheet from the form. I would also like it to update on the home page with a new row that will reference cells in that new sheet. So Currently the user fills in a form and...
  10. C

    Add a SIMPLE progress indicator/bar to an existing Macro?

    Hi guys I've been trying to research how I could add a progress bar to an existing macro of mine but I can't seem to find a reliable tutorial (probably just my poor understanding!). I was wondering if anyone would be able to link me to or help me out with a simple progress indicator or progress...
  11. R

    Auto fill Sumifs not progressing

    Morning all, I've setup a Sumifs to compare dates and split the sum value based on whether it is before or after the date. The date is in column sheet2'!BZ and cell sheet1'!x5. This works on a single line however when I autofill this to the bottom of the spreadsheet, the formula won't...
  12. A

    Progress bar VBA based on time not steps

    I have a progress bar which is based on a loop code. what I need is some code that will run the progress bar based on a time value located in a cell. The macro I am running is a mixture of copying & pasting from one sheet to another, running filters, deleting data and re-sorting. I have no...
  13. J

    Filter Out Multiple Criteria in VBA

    Hi, I am trying to learn how to filter using VBA. So I have column J with items that always varies except for two: "In Progress" and cells that are blank. What I am trying to do is remove everything else except "In Progress" and cells that are blank. I am a newbie and I can't find anything on...
  14. D

    SQL Data import overwriting previous data that report is based on.

    Hello, I have a connection to an SQl Database running on excel. There is another tab with several formulas that all look at the imported table which has several columns. the table imported looks as follows <tbody> Status Department Number in status Date Report Ran Open Applications 7...
  15. V

    Excel Progress Bar chart with Conditional Formatting that Changes Color Based on Value

    I would like create a bar chart in Excel to show the progression that will change color based on the % completed towards goal. I want the progress bar to follow the below color scheme format: <80% = Red Bar >=80% = Green Bar I want this to be one single bar that changes color based...
  16. L

    Listing the values that were added by COUNTIF/SUMIF or gettign the summary of the values (

    Hello, I have an excel with a lot of data (attached excel is just a small portion of it). In this excel, my primary objective is to find the EFFORT by each RESOURCE to each PROJECT. If i use SUMIF, i get the total effort for each resource easily. However, I want to know list the PROJECTS and...
  17. S

    tracking progress through multiple sheets

    hi guys, i need to write a function that tracks progress of a particular invoice through different sheets. I have a main sheet that should show numerical values of 25, 50, 75, 100. My function works with 2 sheets but if i add on more than that it fails the formula for 2 sheets is...
  18. M

    Filter by specific header text

    Hi all, I am trying to filter for blanks on a specific column header and I am struggling to get my head around it/could not find any solution on the net relevant for this issue. I need to use this on about 30 different sheets and every single worksheet has the same text ("Received Progress") in...
  19. S

    Bar Chart For Progress

    Hi there - what I thought maybe simple but I cannot find an answer! I need a bar chart with the various work items along the side, i.e. WORKITEM_1, WORKITEM_2, WORKITEM_3 etc. Along the bottom of the chart I need to have the various stages (these need to be words, and not a percentage of its...
  20. J

    Project progress

    I am looking for an excel formula to identify the latest stage of a project. <tbody> A B C D E F G H I J 1 Progress Stages 2 Project Prepare Start 30% 60% 90% Complete Stage 3 Battersby 21/09/2018 22/09/2018 15/12/2018 30% 4 Phillips...

Some videos you may like

This Week's Hot Topics

Top