completed

I created a form of task and the completed task will be identified by a checkbox as clicked. The field is Task Completed: "checkbox". If the box is checked, then it is completed. The checkbox has to be done by a manager so I need to have to build a pop-up form (frm_Pin) with VBA code attached to...

Hi, i need to have a report, i already done a little, but still need a help. <tbody> START DATE Get the Start Date based on the Task ID WORK DAYS Get age of item in business days upon completion SLA If item is completed within SLA, put 1, otherwise put 0 (refer to the Function SLA table...

Hi All, I work in a hotel and I am trying to create a simple tracking worksheet that will keep track of work orders that we give to our engineering department to get things fixed in the hotel. I know that this would probably be easier to do in access, but given the staff that this will be...

Hello, I need some help, using getpivotdata function for the first time. My pivot looks like this: <tbody> Date Completed Grand Total <tbody> 2018/10/25 </tbody> 33 33 <tbody> 2018/10/26 </tbody> 37 37 <tbody> 2018/10/29 </tbody> 36 36 </tbody> I have a table where I'd like...

Hi All, I having trouble getting this to work fully . The issue I have is that I need to force cells E2:J2 to be completed in order if cell D2 is populated, and to remove any cells that are not completed in order. With this repeating for each row of my spreadsheet. I have a current code that...

good day, For Each rng In Range("h4:h200") Select Case rng.Value Case "Build Completed" With Range("A" & rng.Row).Resize(1, 22) .Interior.ColorIndex = 4 .Font.Bold = True the code highlighted in red is a triggered word...

Greetings all, I am very new to VBA and dont really understand how to use it. I am trying to create a running spreadsheet that has two sheets. Sheet one has columns: Job #| Part #| Part Name | Date/Time Entered | Date/Time Due | Date/ Time Completed | HIT/ LATE Sheet one is a running log...

Hi, Does any have the 'VB knowhow' to highlight a row(s) that contain a certain value? The range is c2:c200 & if it contains any of the following keywords:- base test completed OK - light green\bold base test completed failure - Light red\bold base test on test - light...

I have two sheets for my engineers that have their active projects listed. I have a third sheet for all projects that have been completed. I'm looking for a way to pull all of my projects from sheet 1 and 2, and lump them together in sheet 3. Then, if I could have a column to specify if the...

I know. I know. I've seen this on here a million times, but I've tried several codes, altered them with my info, and they just don't work. I have a project log where multiple users update their progress on certain tasks. When a task is completed I'd like the row with that task cut and pasted...

I have created a workbook to track open and completed work orders. The code below allows for me to move the completed work order from a row on the open sheet to the next available row on the completed sheet by entering "completed". Upon doing this it leaves and open row with one column that says...

Hello, I have been using a great task tracker that when I enter a complete date, it moves the entire task row to a new worksheet, "Completed Tasks." Here is the issue I ran into: When I archive my year of tasks, I save the excel as the following year, then on the current workbook I delete the...

Hello, I have a table with months I and various figures for each month. I am wanting to display in columns O the last 3 months that have data in column D (completed). For Example below August, September and October should have a 1,2,3 in column O This is what I have but it won't work...

How do I make it so I can see which activities should have been completed in a certain time frame (e.g 1 month). Which ones have been completed, and then which ones have over ran, so have not met their deadline. And can these also be counted up at the end? So a total of completed and not...

Hi All, Currently in our department with run all our live and completed works off an excel spreadsheet. The sheet holds alot of different information, which currently I have to manually look up to produce a daily, then weekly report. I'm wondering what formaula's I need to have this...

Hi, I have aset of data on one sheet, with multiple site ID's but each ID will have adifferent set of data as below, once this data has all met a certaincriteria I want to move it onto a new tab the data set is below as an example: <colgroup><col width="64" style="width: 48pt;"> <col...

Hi All, The desired output column, should be a cumulative figure of the area, the criteria being the summation should happen when the status is Completed & names are of the same tech. Example: SJR Tech = 100+200+300 = 600 If the status is Proposed or Under Construction, the output should...

Hello all, I want to start off by apologizing for posting a question that has been answered a DOZEN time, however, I've been tasked with this at work and cannot seem to get the codes to work! What I'm looking to do: Sheet 1 name - 30 and 50 day reviews Sheet 2 name - 30 and 50 day completed...

Hi all! I have what may be kind of a complex issue. I’m currently working with a data set and wondering whether there was a DAX formula that will create a flag that will place students in one of six categories based on the order in which they completed a test. Essentially I would like to...

I am looking for some help with a VBA button in an excel sheet. I am wanting to have a click box/button that says states if the form is completed. Then after i have clicked the completed button/box the current days date shows underneath it. There will be multiple pages in the excel sheet, and...