equipment

So I've done some searching and it looks like I need a VBA, but being a total rookie when it comes to codes I couldn't find anything that I could 100% work with without messing it up. I have up to 50 worksheets in my workbook all named individually such as GD01, EX02, LD01 etc I would like to...

Hi, I'm using the below formula to extract data (equipment number) with a hyphen. For example, cell contains: V-1770A BLAST/PAINT EXTERNAL SURFACE (#17337C) the formula: =TRIM(MID(SUBSTITUTE(E3080," ",REPT(" ",99)),MAX(1,FIND("V-",SUBSTITUTE(E3080," ",REPT(" ",99)))-50),99)) returns the...

I have a spreadsheet that tallies the amount of fuel purchased and used each month. At the top of the spreadsheet, the user is supposed to enter the equipment number and then in each day of the fiscal month, they enter how much fuel was used. The purchased amount has its own column...

I'm working on a data set as displayed below. I need to rank the maintenance and breakdown schedule of few equipment. The screenshot displays the data for 2 equipment with their maintenance schedule. Column 1&2 lists the Start date and time, Column 3&4 lists the completion date and time of...

I have in a table 3 fields a Start Date / End Date / # of Equipment (Columns A,B,C) I want to be able to look at the month and see the sum of the required # of equipment. The issue is the number of equipment is being used everyday from start to end date. So quick example: Nov 1 / Nov 5 / 5 Nov...

Hi, I have a cost model which consists of 5 identical worksheets. Within these worksheets there are different sub headings. Within the sub headings there are 'In-House Equipment', 'Personnel' & 'Third Party Equipment', with one of the sub headings being 'Consumables' What I need extracted &...

I have two columns, Category of Equipment and Labor Hours. Each individual cell of the CoE column is one of a few different categories. Door, Rack, Kit, Base, Shelf, Accessory, etc. The Labor Hours shows the time taken to install specific products, based mostly on category. What I'm trying to do...

Hi, I am attempting to write an equipment accountability Macro in excel, input is serial number via barcode scanner with carriage return appended. I need 3 user forms: 1 to add/remove equipment by serial number and description (organized by type of equipment), another to sign out multiple...