inspection

INSPECT is a powerful data inspection tool providing a summary of all unique values in the selected range/array along with their counts and data types; several additional type-based details for the specified data type; and the ability to exclude/include type(s) in order to focus the analysis on...

I have a spreadsheet with various inspection dates. I would like the fill of each cell to change based on the current date versus the expected date of the inspection. <tbody> Inspection Date Plumbing 4/14/2019 Electric 4/16/2019 Decking 4/18/2019 Final </tbody> What I would like is...

Hi All, I need to carry out 6 weekly and 10 weekly inspections on our units and trailers. How do I set up the sheets so that:- 1) It automatically records the next date of Inspection and respective dates for the next 6 months so that I have a list of due and completed inspections. 2) On...

Hello This is something that has happened to me some times but never understood why. I'm doing a simple calculation which I can easily do in my head, and the answer should be 0 but excel returns a negative 0. Upon further inspection the 14th decimal position has a value, but it should be 0...

Is there a non-macro way to dynamically reference named ranges? I use a database at work for tracking inspections on equipment. I have no power over the database and can only pull a two-thousand-row long report with the pertinent info. The database report has an individual line for each...

I have a very large excel spreadsheet (excel 2016) that is used to track a bunch of gear that is issued out to individual people. Basically I have a column with serial number, a column with inspection dates, a column with issued dates, and a column with names. The gear I have in this log has...

I am trying to come up with a way to have the exact contents of one cell in another cell and retain the text format. For example: Cell A2 "Item I-34 NVG Inspection - complied with 100 hour inspection. Next due 123.3" and when I link it to another cell, the text formatting is removed and I...

Hi all, I'm new to the forum and Excel and couldn't find this specific thing on search (or how to word my search), so here goes: I'm trying to figure out how to compute the average date inspection date of a building based off of the inspection date of each asset in a building for example...

Hi Guys I have an Excel workbook for Contractor Vehicles which has the date's of site vehicle inspections. Every 3 months we ask for an updated vehicle inspection. I have an EDATE formula to calculate when an inspection last occurred (column I - manual input); when an inspection will expire...

Hi, I wan't to use the vlookup formula that needs to search with a variable workbookname. This variable workbookname is in cell N15 and what I have is this: =VLOOKUP("Diameter_ 244.175";'J:\Kwaliteit Helmond\FINAL INSPECTION...

hello all, i'm not a vba user but i was able to do some basic command to reach my goal. I have created a command (in the sheet ThisWorkBook) who tells me which bridge need inspection soon (i'm a bridge inspector!) it works fine. At the opening, every time excel find a bridge with inspection...

Hello. I am a first time poster here. I am used to using lookups, but stuck with moving to a situation where I have multiple matches and want to apply a criteria to return a single value I am interested in. The data below show some inspection data for care home quality, which include some...

Okay, I'm stuck. I have a command button that collects data from the bottom row of a table in excel and populates bookmarks in a word template. The code seems to work upto the point where it saves the created word document to a file path. The error I'm getting is "remote server machine does not...

Greetings, below is a snippet from some code that I am using to create a backup copy of a WS, I haven't included everything, just the first part that I believe will pertain to my question. I have been noodling and searching for this for a bit but I am not having much luck. You will notice...

I have a continuous data entry log (example below) and i want a formula at the top to indicate whether data needs to be logged or not based on the values entered below. There has to be at least 25 data points collected. I want to make it so that it says something like this in a formula. 1...

If cell A has a date, cell B has either MOT or Inspection. How do I create a formula for cell C to calculate one year on if cell b says MOT or 12 weeks on if cell B says Inspection?

Here's the situation. I have a pivot table the presents all the information I need. Now I need to extract the information in a particular way to "concatenate" on to one line based on a condition with a particular format. An example of the table is below. <tbody> Site Activity Component OMG...

Hello, First I need to give a special thanks to all members here. I learned SO MUCH vba in here..! I've build many excel files very complexe and they are constantly used at my job. My last project is an Inspection report for my inspector. (I'm working at a machine shop). I built a file that...