maintenance

Hi all! When I open my excel book it takes forever to open due to poor coding on my part. I have a bunch of codes like the below code. What I want is instead of E:E which I believe is why it takes so long to open I only want it to check cells in the actual table or until it hits a blank. I...

I have some data that I need to flip and copy & paste vertically based on the value at the intersection of a row & column. Below is the data as it is currently & how I need it to look. The result is based on where the policy is marked as 'Required' for that job & policy. I have tried various...

Please help with the following as i am running into a brick wall here. i am writing a spread sheet for daily engine maintenance. I have already gotten if service due by hours working properly with the following code. Private Sub Worksheet_Calculate() If Range("G9").Value < 25 And...

Here is an example of what I have and what I would like to accomplish. <tbody> OPEN WORK REPORT Period NUMBER WORK ORDER DESCRIPTION TYPE 25524484 ACCIDENT accident rollover Period NUMBER WORK ORDER WORK ORDER DESCRIPTION TYPE 25858720 BULK ISSUE Bulk...

I have a form that when the user double-clicks a listbox, the record is retrived and placed on the form for editing. I keep getting the runtime error when I try to clear the form. The code is below. 'Traverses form and clears contents from textboxes For Each cCont In Me.Controls...

Hi all, I want to make a "simple" maintenance plan that can do following tasks: to check when opened if the planned maintenance week has passed or is this week on sheet2 column BG, and if the maintenance to specific machine number was not done (columns BK, BM, BO and BQ) and display the results...

Hello, which formula could I use to find the due date of a maintenance contract based on the maintenance frequency (e.g. every 1 month), start date of the contract and today's date? Example: A security barrier contract: the contract is valid from 10/01/2018 till 10/12/2018. The frequency of...

Hello, I wou l'd be very grateful to the one who would be able to help me with this : I am trying to calculate the next due date based on today’s date and maintenance frequency (days, months and year)…. Would you be able to add your magical formula for the ‘maintenance period’ and ‘days to...

Once upon a time our Maintenance department used a software package that sat on top of an Oracle Database within our network to manage all planned and unplanned Maintenance activities. A decade ago I built various automated reports from the background tables and created tools to allow the...

Hello all, I have a situation where i have multiple plants sending me files that i copy and paste into a master workbook with all the plants info. I have found ways to copy from workbook 1 to workbook 2, but only with specific ranges or an entire sheet (sort of hard coded). What i want to do...

Hi there, I'm relatively new to Excel and I have created a Workbook with several tabs holding all our equipment, their service/PAT test dates and conditioned the cells to turn either red/yellow/green dependent on whether or not the date is satisfactory. As there are a large amount of equipment...

Good Afternoon, 1st time VBA user - please be gentle... I have built a schedule tracker for maintenance in Excel. Dates when maintenance has been completed is entered into Sheet 2 for the corresponding piece of equipment/task. From this date a 'next due' date is populated on Sheet 1. Sheet...

Hi guys, See below, I have used the following formula intending to retrieve the red bits. =LOOKUP(MID(A2,3,2),$J$1:$K$5)&LEFT(C2,5)&"-"&D2&"_"&"PN_"&B2 instead, it Returns as: Finance_Department_43107-43287_PN_876789 I tried to Change the Format cells as Dates, it still won't work. oddly...

I have three data sources that I need to consolidate into a single data source: 1. A list of maintenance periods which are uniquely (no repeats) identified by 4 letters and 3 digits, for example CANS118. The Maintenance Periods mentioned in the data sources below will be listed it this list...

Guys I have the scenario below where I would like to create a loop to distribute along the columns (G column on) the date that that maintenance will ocurr based on its ID, Frequency and Due date. I will distribute it for a period of 01 year (365 days or 365 Columns) For instance, the...

Hi All, i have a few hundred rows of data for maintenance for trucks and the the unique data is the registration (rego) with its status The rego could be in the column a few times as it might have a few maintenance issues. Once the maintenance issues have been fixed we change the status to...

Hello Experts, I need you help to calculate max and min values Based on Designations. Any suggestion please. Thanks, Kamran Noor <colgroup><col><col><col></colgroup><tbody> NAME DESIGNATION PAYROLL SAIRA MALIK ASSISTANT 19,180 FAIZA ALI ASSISTANT 19,970 MUHAMMAD IMTIAZ...

Hi! I have two lists of dates for a project, one is the Maintenance Dates and one is the Production Dates. I'm trying to figure out for each Production Date, how long has it been since the last Maintenance Date. The Maintenance Dates will be far less frequent than Production Dates, obviously...

I want to write a UDF (maybe multiple ones) perform calculations for a fleet of vehicles as to when to perform a maintenance or quality check. Not so simple when I factor in some time frames (rated by mileage) these maintenance's need to performed. So my first scheduled maintenance is to be...

Hi can you help, I have two spreadsheets that i need to merge on a daily basis. Copy below. The number field is the unique reference. What I would like to do is find a formula that can look at the reference number in the master spreadsheet find the same reference number in the daily excel sheets...