progress

I've looked high and low and cannot seem to find the answer to this. I am looking to show registration progress since the start date of the project. Basically, we rolled out a new program and have had difficulty getting some of the people to register for it. I would like to show a combo graph...

Hello, i have a data need to be fill when ever i made a progrees. Each column are fill with date the progress made. Is it possible for me to made the last column to state the current progress based on the last column that has been filled with the date? i wanted at the current progress column...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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