device

Hi, I have had a look around online but can't seem to find what I want. I have devices in one column and dates received in another. I do not wish to reorder the column as they are set up in device order. I want to find which device was received the earliest. Please can someone advise the...

I have a pivot table that is tracking occurrence per device as follows: <colgroup><col><col></colgroup><tbody> PJ1065 1 PJ1089 1 PJ1156 1 PJ1197 1 PJ1573 2 PJ1754 1 PJ3159 1 PJ3223 3 PJ3648 1 PJ3944 1 PJ4064 1 PJ4073 1 PJ4309 1 </tbody> I need to find a way to...

As part of some prep work I have found myself routinely doing, I have to update column J in 6 worksheets by replacing the device or tag id number with the available name which could be in an adjacent cell in columns K through P. I say could be because one or more of the cells could be empty. I...

Hi all, is there a way to get serial number of all usb flash driver with vba ?? I found a code in below website, but it gives Device id while I need to serial number of usb : https://myengineeringworld.net/2014/01/retrieve-usb-device-information-vba-wmi.html can someone help me?? Thanks in...

Hi guys I am trying to do a backup spreadsheet for all the devices at work (each device has 32 "nodes" in them so its one sheet per device) I have got everything working on each sheet (expiry dates, filters macros etc) but I am trying to set up one front "Status"page that shows you if work...

Good afternoon all, I am trying to find a way to calculate our devices downtime during our Performance Measures hours for each month. As of now i add each device,from each shift, each day for the entire month. Example: Performance Measure hours are Monday-Friday 5am to 9pm. We have three shifts...

I am trying to calculate the number of remaining errors in a list of total errors, sorted by type of error, as follows. I have tried both COUNTIFS and SUMPRODUCT with no success. Help Please!! Target Cell for the formula is I1. I need it to calculate the number of cells in column I table...

Hello all. Here is the scenario. I am using Excel to track the inventory of desk phones(among other things) This screenshot is row 8. Here is what I currently have for the H Column =IF(G8<>"",INDEX(AD_Username,MATCH(G8,AD_Locations,0)),"") The phones are assigned to a particular seat or...

Hi all, I am designing a staff training records on devices within our organisation. The workbook consists of the following spreadsheet tabs: Devices, staff list & staff requirements. In staff requirements spreadsheet, it has the staff details from staff list spreadsheet on the left of the table...

Hi I have scenario like the following: I do not want to allow 2 material to have same week (to be borrowed same week). I want to give a user an message saying he can not have that week because other device reserved that week. For example Device 10 is taken in week 4 then later device 200 is...

Hi Everyone, I have downloaded a VBA code from internet for gathering data from rs232 device through excel. My problem is i cant get the data from the rs232 device to output to excel file. I already test the rs232 communication and its working fine, i can send and receive data from the device...

Hello and thanks for the help in advance. I have been googling and trying to overcome this issue for days and cannot seem to get Index, Match or Lookup formula's to work. I have the following 2 Worksheets in a single Workbook (raw file gets converted and VBA code copies the second sheet in -...

Hi All! I have able to written a code where i can select which workbook i would like to use as a reference. It works fine however when the vlookup finds data i got N/A despite the exact data Here is the code LastRow = Range("B65536").End(xlUp).Row Range("AA2:AA" & LastRow).FormulaR1C1 =...

Hi Everyone, So I have a spreadsheet with many columns and rows but I am only concerned with two columns here. One is the Employee ID (Column C) and the other is Device Type (Column P). The device type has seven different options (Aircard, PDA Voice/Data, Telemetry, Cell Phone, Satellite, PDA...

Hi I've created a spreadsheet to record VAT returns for a small computer repair business in Ireland. I like to tweak it to make it run smoother and faster - it has a selection of if statements working well but the macros are proving too difficult to implement. There are two applicable VAT...

Hi, I am trying to create an Excel spreadsheet using three different sheets. Sheet one will be a sheet a user can select a device and operating system and it will pull data from sheet 2 or 3 displaying the number of users for that device and operating system etc. Sheet 2 and 3 will contain...

You can arrange your file in excel by using hyperlink, so when you click it the file will open. But if you share your excel through other device and want to open the file from that device, it won't open. Don't worry, you can embed the file so you can from other device by using this way : insert...

I have a MS-Excel Workbook with 100+ Sheets. I need come up with a dash board like, fetching the information based on Column, C D and Column E and to have a count based on Column E, grouped by per Sheet and all the sheets Column C Label is ''RACK Column D Label is 'Device No.' Column E...

Hi, excel masters. I don't know much about macros and VBA but I know that this can be done. if someone would be nice to help me, i would be tremendously grateful. Thank you here's what I want to achieve, 1. I want to eliminate all texts that have "KM", "Litres", "Liters" 2. I want to...

Hello. I'm trying to automate a tedious task of typing each device number manually. I wonder if there is a possibility of creating a macro that'd speed up the process. All other values are given beforehand. The logic behind each device number goes as follows: First two numbers are fixed and...