serial number

  1. V

    Add Serial Numbers in new column up to last row based on next column

    Dear Community, I am returning back to VBA after a very long break and have managed to forgotten the code to run a macro that adds serial numbers on the left hand side of a blank column from start of the data up to the last row based on a column with last row data which can vary in legth from...
  2. R

    Increment Cell Number based on Date & Time

    I have tried everything out there from google search to youtube videos but cannot find anything to help me get to the below example. Does anyone have a formula that would work? The top set is based on the date and time in column b. The bottoms set is based on the date in column b and the time in...
  3. T

    Assign unique increment ID based on two conditions

    Hi everyone, I've always been a big fan of Mr. Excel's YouTube videos and thought I'd participate in the forum as well. My first post is in relation to the project I am working on. I am hoping somebody could help me out. Been searching for hours on the web and stumbled upon some possible...
  4. S

    Serial Number Logic

    Hello, I am trying to have a serial number logic, as below:- <colgroup><col><col></colgroup><tbody> Sr. No. Code 1 AB005 AB005 2 AB006 3 AB007 AB007 4 AB008 </tbody> Column 1 is Sr. No., Column 2 is Code Number. Now, I am need that Sr. no. should ignore while dragging, if...
  5. Y

    VBA Find Part Number and highest Serial Number and add 1 to last row

    I am having trouble coming up with a VBA code to find a part number I am searching for and then finding the highest (or last row) serial number, adding 1 to that number and creating a new line item. <tbody> Part Number Serial Number Description 5462H 023 Pan Head Screw 6524X 018 Washer...
  6. U

    Macro to automatically enter serial numbers as per row count

    Table 1: Sheet 1 <tbody> Sr No Salary Gender AGE 1 2000 M 23 2 3000 M 24 3 4000 F 25 </tbody> Table 2: Sheet 2 -Before Macro <tbody> Employee Details Eligibility 3 4 5 </tbody> Table 2: Sheet 2 - After Macro <tbody> Employee Details Eligibility 3 4 5 </tbody> I...
  7. M

    Select a value from a comma separated list based on a serial number

    Hi I have a list of student needs (comma separated) in one column, with the rank of those needs (also comma separated) in another column, but the problem is, the rank is not always in a logical numerical order: <tbody> Column A Column B ASD, SEMH 1,2 SEMH, MLD 2,1 SLCN,SEMH,ASD 2,1,3...
  8. M

    Custom Serial Number Format Based Upon Julian Date.

    Hello: I need to create a serial number that auto increments based upon the following format: Last two digits of the year + Julian day of the year + two digit unique incremented number. 1610604 would be 2016 on the 106th day and the 4th unit and the next number would be 1610605. I do not...
  9. A

    Assign "serial number" that NEVER changes again...

    Hello Everyone, I've been searching for a few days for the solution to my problem, but nothing fits the bill. Imagine a system for recording Invoices. The invoice number cannot be re-used, and must not change after it has been entered (or rather, looked up from a counter). Is there any way to...
  10. A

    Serial Number in Pivot table

    I have data below mentioned detail <tbody> Date Name Region Collection 21-Sep-15 Muhammad Ashraf TTS 70,000 21-Sep-15 Shahid Nadeem TTS 210,000 21-Sep-15 Abdul Wahid TTS 170,000 21-Sep-15 Javed Akhter JNG 49,160 21-Sep-15 Iftikhar Ahmad JNG 100,000 21-Sep-15 Ghulam Murtaza JNG...
  11. N

    Serial number with last 4 digits resetting every year.

    Hi I currently have a great macro that, when a "generate" button is pressed, it puts out a serial number in the format of YYMMXXXX (where XXXX begins from 0001) and populates the next available row with this number. However we now need it to reset the last four digits to go back to 0001 every...
  12. C

    Serial Number

    Hi there, I want to track an individual across a number of years. I have their name eg: Smith, John and I want to track this across different years databases and find how this person's qualifications changed across years. I was thinking of assigning a serial number to an individual but need...
  13. E

    Style number / part number auto-populate in 2nd table

    I am a novice in excel (2010). I own a t-shirt brand, when I put together a print run with multiple designs, that have multiple colored shirts per design (as shown in my screenshot). I need to then total up the number of: SMALL BLACK-T, MEDIUM BLACK-T, SMALL BLUE-T, ETC from all designs...
  14. E

    Serial number grab using vba

    <br> Halito!<br> <br> I am attempting to find a code that will grab the serial number of the pc and insert into cell A1. I have found the below code and it works, but it requires you to enter the name of the computer you need serial from, then displays serial in message box. I just want it to...
  15. F

    Serial Number With Alphabets With Formula

    Hi, I need a formula that if i drag it down it gives me serial number with alphabets. Like if i paste that formula in cell A1 it give me serial number AAA 0000 and when i drag it down it give me AAA 0001. When serial number reaches AAA 9999 it automatically give me AAB 0000 and it goes on like...
  16. S

    Stock inventory cout with serial numbers sorting query

    Hi guys. I have a scanner that scans stock barcodes and serial numbers into a memory chip on the scanner.I then dock the scanner and download the info into excel. I need to sort the data into 2 columns based on cell contents. If I scan an item without a serial number, I just want it to...
  17. D

    Date code serial number in excel

    I need to convert a date into a serial number. The serial number must return the format DDDYYNN where DDD is the day of the year, YY is the year, and NN is the sequential build number. As an example, if 10 units are built on 2/6/2013, the serial numbers would be 0371301, 0371302 ...0371310. Cell...
  18. A

    Formula for inventory tracking with Serial Number

    Hi, I have an excel file to keep track of inventory. 1st tab is an overview of the quantity available for each item. column A "Product Code", column B "Description", column C "Qty on 12/1/12", column D "Qty In", Column E "Qty Out", Column F "Total on Hand". 2nd tab in the tab where I insert...
  19. P

    Serial Number increase with letters and numbers

    Hi Ladies and Gents, I have been reading through some of the older questions and couldn't put together my answer without asking for help. Basically what I am looking to do is take a serial number and have it increase by one. The problem however is that the number ends with a letter not a...
  20. B

    Event Ticket Serial Number

    Hi , I am in the midst of fundraising for a Gala Day and I need to creat tickets for a bingo tea. I want serial numbers on them to avoid counterfieting. (Yes, it is that type of place) I am looking to have the serial number in Column E Due to the text the Rows are likely to be 4,8 , 16 etc...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top