equipment

  1. A

    VBA Entry and Verification Form

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

    Not a trick question, what is wrong with this formula

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

    Using IF function with VLOOKUP for VBA

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

    Leadtime analysis

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

    Auto Generate Data-Sheets

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

    Reference Cell Data in Open Sheet Only

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

    Insert Rows

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

    Estimate Work Orders Per Year

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

    Reoccuring events in Excel schedule

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

    Possible VLOOKUP with IF Statements

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

    AutoFill to every 3rd row

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

    Working with images

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

    Conditional Formatting Based on List

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

    Pricing comparison

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

    Get notified when four cells met my requirements.

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

    Multiple cells to open one userform

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

    Memo field on form in multiple columns?

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

    Form Help

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

    How to use object variables in .Formulas VBA

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

    Dynamically Reference Named Ranges?

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top