serial

Hi All, I have a table showing contents, by serial #, in numbered storage boxes, which increase daily Example. Each box could have different quantities <tbody> Serial# Box# Comments A100 Box 001 Photos A101 Box 001 A102 Box 001 B100 Box 002 Documents B101 Box 002 B102 Box 002...

Hi, May i know how to write a code to sum up the numbers of each date in second column and write it at the side of each serial number (For example : location A and B)? As you can see, serial number 1 has 2 dates and serial number 2 only have one date, how do i write a code to sum all the...

Hi, Let's say I have a list with orders with every row has seller ID and a product serial nr So it could be (the name and serial nr are different cells) John A23 John A23 Marcus A25 John A25 So in another sheet I have A23 A25 John 2 1 Marcus 0...

Hello I have one excel file with 4 sheets. all 4 sheets have the same columns. the first three sheets have different values but all contains in the first column a serial and all the other colums contain data about each serial and the fourth sheet use index match to show all the information of...

Hi all, I have 1400 Serial number that have a series of codes associated with them. There are too many for a pivot table so I cut/pasted them to a new spreadsheet. I would like to move the codes from under the serial numbers in column A to the rows next to the Serial Number. Can anyone help...

hi, ive been successful in creating an estimation sheet based on many different sheets combined in the same workbook. now to offer a bid, ive made a separate sheet by name of BOQ and collected all information/calculations from different sheets into that BOQ and all new items can be added in the...

Morning, Afternoon or Evening All, Now i am not sure if this is in the right area but it is based around excel. I currently have a excel file which is designed to work on a touch screen where a user scans in a serial number then touches different pictures to highlight issues with a product...

no matter what i try, i cant get vba to return the serial number of the date. i want for example, to input this: 6/18/2018 and return this: 43269 in a worksheet, u change the format to general, but how to do this in vba? Thanks!

Hello, Let me begin by saying I am a beginner when it comes to macros in excel. I have an excel sheet with a password protected macro that I am trying to duplicate. Disclaimer: I own the original file and have legal permission to use it as needed, but the passwords have been long forgotten and...

I have a spreadsheet to keep track of lab equipment. I have the Serial Number column set to find duplicates and highlight them with a red background. The entire column has the cells formatted as TEXT. I just came across a problem with two separate items that show as duplicates. For the first...

<tbody> comments serial no. model no. part no date serial :1235468 model: III-5400 part :tab3gd1 D:05/08/2018 56788 III-555 gac56r1 05/08/2018 </tbody> Hi All, Please I need help in this matter. I have over than 300 rows. and I have a column of comments with data in each...

Greetings All, I have a school the runs 30+ computers. Recently, we had a lot of them stolen. I would like to have my inventory not only list the SN of each, but also a lot of the fine details that help recover these items if it occurs again. I am a start-up school, money is very tight, so...

I have this problem, I have three columns with data: A B C 1 98 98 ? 2 98 3 12 4 98 5 02 Column A has the serial numbers of all my products, column B the ones that have been sold, and column C I need to...

Hi Guys, as indicated, the numbers marked in red are the expect results, process and registration fee will be extracted from table 3 and cost will be extracted from table 2; couldn't really pinpoint what formula to use, a few look ups ? could you help me with any formulas with regard to this...

Hello, I have 222 columns of data in one table that I need to compare to another. What I want it to do is: Highlight in Green if it matches and Red if it doesn't. Basically a report is "Exported" from software and pasted into the excel file into the tab "ChExport" Then I want to run a...

Hi Excel Gurus, I am currently working on a Project that requires me to look up the respective value: Here is how it goes, I have got 2 workbooks, one is the master workbook that contains data such as: Workbook 1 <tbody> Serial Number Contract fee Maintanence fee Contract cost Maintanence...

Hello ! As you know, the letter of an USB device can change. If you need to use a USB device in your VBA application, is it possible to use this: 'declaration Public DRIVELETTER Public Declare Function GetVolumeInformation Lib "Kernel32" Alias "GetVolumeInformationA" (ByVal lpRootPathName As...

Hello ! As you know, the letter of an USB device can change. If you need to use a USB device in your VBA application, use this: 'declaration Public DRIVELETTER Public Declare Function GetVolumeInformation Lib "Kernel32" Alias "GetVolumeInformationA" (ByVal lpRootPathName As String, ByVal...

Here is my problem... 2 excel files need to be merged. The new file has updated info i.e. calibration factors of equipment with unique serial numbers. the old file is with old calibration factors and past due dates. Also old file contains calibration factors and due dates not to be updated...

Can i get any link to download or know where i can find such a database ? I need a serial number tracker and to allocate certificate to a branch & then branch to allocate it to an agent .