serial

ws1 has Names in column B, and Serial Numbers in column C. Some names are duplicated due to a single person being associated with multiple serial numbers. I have a user form that uses the selected cell to populate TextBox1 upon activation. I want ComboBox1 to list all of the Serial Numbers...

I have what I *think* is just a complicated IF/INDEX/MATCH problem that I have not quite been able to figure out. Hoping someone here can help. I have two data sets which I am trying to merge. Dataset 1 contains a series of cases defined by a 9-digit serial number, a 4-digit ID number...

I have what I *think* is just a complicated IF/INDEX/MATCH problem that I have not quite been able to figure out. Hoping someone here can help. I have two data sets which I am trying to merge. Dataset 1 contains a series of cases defined by a 9-digit serial number, a 4-digit ID number...

Hi!! I would be most grateful if someone can help me with a rather (at least for me) complicated macro. I need to print the same excel sheet many times, each time I print, I need the copy to have a serial number and a serial date starting from where I have specified. eg) Cell A1 from 10 to 40...

<tbody> U V W X Y Z AA 6-Nov-18 7-Nov-18 8-Nov-18 9-Nov-18 10-Nov-18 11-Nov-8 12-Nov-18 </tbody> Hi all, not sure its possible but I have "A" column with serial numbers in 123456 and column "O" with dates in, what I'm trying to do is when I...

Greetings all, I have a question about the following code erroring out. dim res9 as variant dim res4 as variant res9 = application.match(combobox1.value, Range("B:B"), 0) res4 = application.match(combobox2.value, Range("B:B"), 0) Range("e" & res9).value = userform4.textbox1.value Range("e"...

I have a document that I track multiple serial numbers of reports. The trick is that reports initiated by our company have a unique serial number (N00164-18-0001) and reports that are initiated by outside users have a different serial number so the excel spreadsheet has mixed reports going down...

Hi everyone. want to assign serial number in column A like 1,1,2,2,3,3 and like using following vba code but asssign serial number like 1,2,3, and like Sub FillSerialNumbers() With Range("A3:A" & Range("B" & Rows.Count).End(xlUp).Row) .Cells(1, 1).Value = 1 .DataSeries...

Hi I need a VBA code for auto insertion of the Serial number in column A when entry in Column B Than you

Hello, I have a sheet with few hundreds of lines and I need to sort them based on the occurrence of serial number in column A. Some numbers appear only one time, but I have some that appear 2 or more times. I need to have a sort like this in another column: - serial numbers one time = 0 -...

https://drive.google.com/open?id=1-kA3-Z4sFfSET2uHxkHnjFu9wiJRvVB_ Please find the attachment above there are 3 columns, serial number,co-ordinates(x,y) coming to serial numbers it is not in proper arranged serial number EX:(1,2,3,11,14,15,18,....214..) i want to arrange serial number...

Hi, I have Data Sheet of a students, in which serial number and name of each student are given together in one cell. Is it possible to add only serial number of all? <tbody> ABC School Class VI Students 1 xxxx 2 xxxx 3 xxxx 4 xxxx 5 xxxx 6 xxxx 7 xxxx 8 xxxx 9...

Hi I want to know if there is a way of showing the difference between two numbers between one month and the next for multiple serial numbers below shows one serial number with a running total for the device monthly. There would be other serial numbers in the mix also. I need too know the...

Hello, I need a VBA code to generate serial numbers as described in the below image (link) Can somebody please help me with this...?? Thank you very much in advance...! http://drive.google.com/file/d/1pFIU3cghghJAuYApKUtx1kYFcD1Ec7bb/view?usp=sharing

Hi: I have a set of long serial numbers formatted as shown below. I want to return ALL text and numbers after 991- Example: 600-1150301-520-199-991-CPG1500-- Required value would CPG1500-- Could you help please? Sean

Hi, I need help to generate serial numbers as explained in the image (below link) Sorry I didnt understand how to attach an image in this form.. Solution either in the form of formula or in the form of vba code, both are acceptable... Thank you in advance...

I have a form that extracts the date automatically from the serial number. So user fills in the serial number in the first sheet and it calculates the serial number into another cell and then that cell is copied into the second sheet which is kind of a form letter but sometimes the value is...

Hello Guys and Gals, I found this macro elsewhere, and modified it slightly to fit my needs. However, I'm unsure how to turn it essentially into an IF statement where it returns "SN Found" if it does find the serial number or "SN Not Found" if it does not find the serial number. I would also...

Hello, everyone I have three columns, F, AC and E. On column F I have the name of a Risk and on AC I have the department which have identified such risk. I'm trying to give a serial code to risks on colum E. Things to consider: - Each department can identify the same risk more than once. In...

I want to remove duplicate serial numbers from column A but the 1 serial that will be kept should have network category from column of "NW*" Secondly I want to keep track of which serials will be removed so i will add another column and replace the removed serials with "To be removed" and the 1...