serial

Hello, having one heck of a time with a seemingly routine VLOOKUP. For some reason, I cannot get this to work - I've tried formatting as general, number, text, with no luck. Naming a range, using a locked range instead, nothing. I keep getting a #N/A "value not available" error. Here's the...

I have a question about numbering rows of data in a Access table or query. I do not want to number each row but want to number each time a serial number appears in a table or query. I have already sorted by date and would like to have a reference in the table of each appearance of a Serial...

I have a column of cells that have a bunch of text in them. in that text there are serial numbers I would like to extract. A cell could have multiple different serial numbers that need to be extracted. For example a cell could have: "Exchange + PS43138 Exchange + PS43178" I'm interested in...

I trying to VLOOKUP the serial number & Description from List_tbl and add to Installed_tbl. If a serial number is available return serial, if not return "EMPTY". List_tbl <colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> FLEET BASE SRD AIRCRAFT WUC POSITION...

I have an excel sheet with several columns. 1 column is accessory and another is serial number. The data looks like this 123456 BXA 123456 RGT 098765 BXA 098765 ONL 876543 TYR 876543 RED I want to search/filter on the second column but include all related items. If I...

Suggest with deleting the selected data from sheet through userform, and paste in other sheet4 & Then make sequence of serial number(A column) in sheet1, from 1 to 1500. Help me for above query in vba excel.

I am trying to determine the amount of days between two dates on a matching serial number. My data has serial numbers that were seen in the past and I am only using the same serial number if it appears twice. I want to know the amount of days in between the date fields we saw these last. The...

Hi All. So I am smack in the middle of a full hardware inventory audit. This means I need to use an existing excel sheet that contains asset numbers and serial numbers. My excel headers are like this: Asset | Name | Serial | Model | Site | description | Change Typically I just print this...

Greetings... So here is my issue I am trying to resolve. I want to capture data from my a serial port and place the data in different cells. I am using an Arduino in an application where I do a serial print, in that print I am sending two bits. Each one represents an input pulse to the Arduino...

Good afternoon everyone. i currently have a VBA program that looks to if a vendor is present on a spreadsheet, then goes and sees if that vendor has done any work to parts. the user than can click on a part number and all related serial numbers will display in another listbox. the array...

Please help me with achieving below task. I want to assign same serial number to duplicate values in two columns. If the value in columnB cell matches with any cell in columnC, both will be assigned similar serial number in columnA. Below is the sample data, duplicate value 34 gets same serial...

Hi all, I'm hoping that I can get some help with a formula on a spreadsheet. I'm creating an excel that tracks return products base on the serial number. Here is the layout of the spreadsheet. Sheet 1: Serial Number A = Customer Name B = Brand C = Products Code D = Serial Number E = Date Sold...

First off, sorry for the one off question. My district has tasked me with assigning serial numbers counted at my site with the partial outputs from their SAP system. So, after extracting my site's inventory and inserting my counts into it for conditional formatting compare-n-contrast...

I have an input menu that allows users to input the serial number of a product and then check off what listed parts are either missing or pulled from said product. However, I want to be able to update certain serial number's fields without creating a whole new row for the same serial number...

Evening All, Been banging my head off a wall with this for hours now and it's stumping me completelt. I hav a sheet which has a lot of data in it, there are sevral date columns, all these are formatted as short date, and when the data type is changed to general they all change to a serial...

In my problem workbook, there are a few things I have to work with but cannot change. The user clicks a button labeled "Enter Job Number" which starts the ball rolling and populates a number of cells in hidden columns A thru E. Once that's done, the user then comes to a button that reads "Click...

Hi I have a sheet that has 20 boxes, 5 by 4, B4:D20, F4:H20... R58:T74 In each one has a serial number where my macro extracts an image from web into the box e.g B4:D15 = Picture, C16 = Serial Number and rest of box is information about serial number. Now I need to conditional format all the...

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 really need this. I am thinking about more than a month but i can't get it! I have values (serial numbers) in different dates, i will send a picture for better understanding. I need to calculate the serial numbers which is new, the values that weren't yesterday in my sheet but it is...

Hi all - I've leveraged a code that applies a serial number to a list (unique number starting at 1 to whatever). The code as written didn't have any formatting, which I've attempted to add. The code originally wrote serial numbers as such (1,2,3......9,10). I want the serial numbers to be...