completed

  1. G

    reporting in excel

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

    Not sure what to call this... but i need it :)

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

    GetPivotData Returning Error when Using Reference cell for Date

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

    VBA Coding - how to force all cells in a row to be completed

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

    select from range

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

    VBA Countdown Production Timer

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

    hightlight row(s) based on value

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

    Consolidating data from two sheets, and hiding specific rows

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

    CUT/PASTE Row to Different Sheet Based on Cell Value

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

    VBA Help!!! Copy Row to new sheet then delete Row from original sheet

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

    Moving Row to the next available row on a new worksheet

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

    finding the last 3 months in a table

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

    I have a spreadsheet with a project on, which has different activities with different deadlines, running parallel.

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

    Formula's for Reports

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

    Copy data from one sheet to another if criteria met

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

    SUMIFS using conditions multiple Criteria

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

    Moving a row from one sheet to another and deleting it from the first shee

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

    Creating Categories Based on Order of Test Completion

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

    VBA Help with Button

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

    Verifying Longitude and Latitude

    I am trying to find or create a formula to compare to make sure that executed and completed, latitude and longitudes are a close match to the store longitude and latitudes closely match. I am thinking maybe a formula that will highlight the executed and completed coordinates green for close and...

Some videos you may like

This Week's Hot Topics

Top