serial

Hi guys, have serial numbers with data in row in two different sheets (from main sheet divided later to two different, according the data in row). can someone help with a code to generate serial number after checking what is the max in the whole workbook? i am currently using +1 on the last row...

I have been tasked with a extracting some data from a spreadsheet not being that good i would like some help with VBA all the data is on sheet 1 and there is duplicated through out. the way it is layed out is where ever there is a part number there is a serial number in the right hand cell...

I currently have 2 sheets of serial numbers sheet 1 has all of the new serial numbers on it and sheet 2 has both old and new serial numbers on. I am currently trying to bring all of the old serial numbers into the sheet 1 but due to the nature of index match and vlookup I am only able to pull in...

Hello, I recently took over a position at my work and I am working with a file that was not originally mine. I have warranty registration cards that we receive from our dealers once the item is sold to the end user. When the end user reports a failure they are supposed to submit a credit form...

I have a database in sheet 2 with certain serial numbers and a userform in sheet 1 that allows me to manage this database, including adding new entries. Each entry needs to have a unique serial number. The serial number can not be duplicated. The serial number follows this format TARA-SS-001. I...

Has me stumped. Column A: Fault codes (3 digit, multiple instances in random order) Column B: Unique serial number of part that has the fault in Column A. Data is continuously being added to the table. I want to use a formula to extract the serial numbers in column B into columns unique to...

Hello, Please I need your help, if this is any possible way in Excel I have a userform to show data on a list box, add new data to the sheet, and remove any selected row from the list box and the sheet I have all these buttons and codes working well, and I have uploaded my test file below At...

Hi All, Can any one tell me how to show the hdd serial number in a cell IE: "P1" Thankyou

I have a code that inputs the HDD serial number in a text file, however when I run the code below to check if the HDD serial number matches the number in the text file, it gives an incorrect response. When I put the HDD serial number in a cell, the code response is correct. What am i missing...

Hello Everyone, I'm working on a simple GUI to input serial numbers. I have created a textbox in a userform to allow a input of a serial number using a hand scanner. The scanner will read serial number and submit an Enter command upon completion of input. Using the Enter command allows the...

Hi all, i have code to get my hdd serial number then code in the Workbook Open, this works fine although what i am wanting to do is have this code check the hdd number and display a msgbox that says hdd serial verified, and also show another msgbox that says serial number not valid then shuts...

I have 2 different sets of data in a total of 4 columnsColumns A & B are a set and columnsE & F are a set I need to compare these two columns for duplicatevalues/entries. Column A is a Serial Number and column B is quantity from adatabase Column E is also a Serial Number and F is from a...

Hiya Not come across this before. I wrote a line of code to copy a range in one workbook to a range in another, but the dates in the date column were replaced by their serial numbers. As you can see, I didn't use PasteSpecial Paste:=xlvalues. Now when I select one of these serial numbers it...

Morning folks :) I have 2 tables, 1 with serial numbers in and the other with the hours that the item has been used for like this... <tbody> 526314 632541 145236 634152 854796 964785 </tbody> <tbody> 343 -794 -27 -355 256 1530 </tbody> Is it possible to generate a formula that if...

Thanks in Advance i am using a Formula =VLOOKUP(B3,'xyz'!B2:L2,11,0) but when i copy and paste it, s.no. of B3 and B2 will change but i want that only B3 serial will change and other value will not change

Having issues once it comes time to reference another sheet. So each device I am trying to find (~300 over 15000 rows) has a specific serial number always in column B. These are on Sheet1. Once that cell is found, there is a set table size I am trying to make, 150 rows long, and extent from B...

Hello First post so here I go... I have a customer who has a unique identifier (ACODE) and a list of serial numbers in separate columns. I want to search for a serial number and then know which customer ACODE owns that serial number. <colgroup><col style="text-align: center;"><col...

Guys For security reasons I want that my workbook can only be used if it is on a network. This network sometimes is mapped by user with different Letters. I would like to find a way to get the serial number of the network drive based on the UNC path instead of Drive Letter. But I would like to...

Looking for some help? I have a spread sheet with approximately 500 line entries that include (Make, Model, Serial Number, etc..) I want to take my monthly list of serial numbers from another source and apply them to the current spreadsheet so that the line items would...

Hi, Long time reader, first time poster... I have a table with with a list of values that represent serial numbers. Im looking for some VBA code that will check a specific directory to see if someone has added a file where the filename contains one of the serial numbers and updates the value...