equipment

VBA Scripting is NOT my strong suit. (VERY BASIC USER HERE) I have a data set of users due for a PC refresh. My manager wants to get our techs to fill in a data sheet indicating when a user has picked up their refresh, but does not want to give all the details from the dataset to the techs...

So I have a column of formulas. I clicked and dragged to autofill the formulas and at some random point, it stopped working. Can anyone see a difference? =IF(A123=0,0,VLOOKUP(EQUIPMENT!A123,EQUIPMENT!$L$3:$P$2888,5)*B123) This is the last one that worked...

I currently have an excel field using a formula and data validation. The formula is an IF statement that looks for any text from one cell(ie equipment part number) and then applies a VLOOKUP to find the name of the equipment. Based on the output of the VLOOKUP there is a data validation for a...

I was wondering if someone has a leadtime analysis worksheet they would be willing to share? I work in a third party contractor industry where we come in and install various pieces of equipment when the builder is ready for us. Equipment deliver is all over the place. My goal is to set...

I'm fairly new to VBS, but have done lots of work in C, and C++. I'm having a hard time figuring out if what I want to do is even possible. Basically I have a lit of equipment that needs servicing each with a unique ID. The equipment can be broken down into two main categories. Each of these...

I have a workbook with a set of timesheets (labour & equipment) one worksheet for each day of the month. There are master (long list) sheets for Workers and Equipment, and I am trying to shortlist the worker and equipment sets from the master lists sheets (location or area dependent) to create...

Hello all, I created a workbook to keep track of maintenance records for some of our certifications and equipment. I am trying to insert a row below each header row for continuous data it works off of a command button and at the end of a year it will add a new row for each cert or piece of...

Hi, Using O365. I have: Install Date of new equipment over various dates (fairly recent) Repair records for the equipment since the install date Some equipment is no new, no repairs as of yet. How can I use the data to estimate a number of repairs/equipment/year? Thanks, -Lou

Good morning everyone, I am working on designing a schedule for equipment in mycompany. I have recently learned about aGannt chart and have been able to build one in my workbook. When a place a start and stop date by a pieceof equipment that time is then blocked off. Here is my problem, often...

Hi, I'm looking to be able to build a report table based off of data from another table. Basically, I'm looking to get the serial # for a certain piece of equipment if all my conditions are met in one cell, and calculate the age of the equipment based of the respective values for that same...

My work uses spreadsheets to display the current inventory for companies we rent to. The way they have it formatted is, starting in A56, they'll have "Box 1", in A57 they'll have the serial number of the equipment, and then A58 will be blank. A59 will be Box 2, A60 will be that serial number...

Hi All I have several pictures of equipment to the side of a sheet that is like a library. When I need to grab these pictures, I scroll over to look for it and then copy it and paste it to where I need it. I'm looking for a shortcut that I'm guessing isn't possible. Something like: Type the...

Hello! Simply, I was wondering if anyone had a method for conditional formatting (Font Color) for a row based on whether or not the last four digits of an asset appear in a separate table. (Table A) I've got a spreadsheet that has a large list of equipment as well as columns with current...

hey; i need your help; i have a sheet containing 500 types of equipment each equipment has 2 or three prices and i need to get from it the min price , average and max prices and returning the supplier name for each value

greetings every one, i hope you are well and safe. This web helped me a lot so, thank all of you for your support. i have a small problem that might be solved here of course. i have 4 types of equipment listed in the excel sheet using the PI add-in tool to extract the running hours for this...

Still relatively new to coding. I'm trying to build an equipment schedule so I know where gear is going/has been. I'm trying to set it up so I can double click the piece of equipment which will in turn run a user form. It works for my first line (A3), but not for anything after. Private Sub...

I feel like a grade schooler with access, but slowly getting my database to a usable format. I have a report, generated by inputting a person's last name, which produces a one page document of all issued equipment for that person. On that report, I have a Memo field, which I'm using to store...

Trying to create a form in Excel that will allow a technician to input a username, click on one button which will then search the sheet for that user name. If username is true, script then looks to see if equipment has been assigned to user. If false then a new form comes up, populated with...

Hi guys! Long time reader, first time poster :D I've created a quote calculator for our company and having trouble getting costs for a specific products summed up into one cell. I'm trying to write a formula in excel VBA to sum specific values from different worksheets. I have 2 different...

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