calibration

I have created an excel table to manage calibration expiration dates for tools that we use. One of the columns in the table is titled "Next Calibration" and has a list of upcoming dates (6/25/2019, 7/14/2019, 8/30/2020, etc.). I have already used conditional formatting to highlight the upcoming...

My department has task that are executed daily, weekly, monthly and quarterly and these tasks have been placed in a name range list called "task" where the headers are A1= Frequency, B1= Form # and C1 = Task Description. 4 rows or lines of data reads as follows: A2 =Daily B2 =27 C2= Preop...

Here is my problem... 2 excel files need to be merged. The new file has updated info i.e. calibration factors of equipment with unique serial numbers. the old file is with old calibration factors and past due dates. Also old file contains calibration factors and due dates not to be updated...

Good Afternoon, I have tailored the following code to enable me to e-mail a selection in my workbook to specified people at the push of a button: With ActiveSheet.MailEnvelope .Introduction = "These are the items Due or Late for Calibration - please review your items and confirm they...

So I have the following code.... Sub CalibrationCopy() 'CalibrationCopy imports the calibration data that is relavent to the current setup. ' Call in Variables Dim CalibSh As Worksheet Dim i As Long Dim LastRow As Long Dim CalibDate As Long 'Import Data...

Hey All, I was wondering if there was a way to conditionally format a cell based on if a certain row of information has been entered. Put in more layman terms. I have a workbook which has a master sheet filled in daily. On this sheet I have a cell which I manually change it's background...

I need to copy calibration data from a master calibration file into a report file (to display the daily calibration in the report). My goal is to put a button on the report excel sheet that will search the daily calibration for all the data that has been entered that day. (The date will be...

Hi all, relatively new to excel and definitely to this forum so please be gentle!:laugh: I have a spreadsheet where I need to track when items need calibrating which is every 6 months. There is a column that records its last calibration date but what I would like is somehow for that column to be...