unique number

  1. S

    Creating New PO#s in a Table

    I'm taking over a spreadsheet made by someone else. The person is not contactable for assistance. I have a table that spans from A4:W514 and is called "CheckbookTable". I need a macro to create a new line in the table, but each new line needs to have a new and unique PO# in column L as well as...
  2. M

    Generate Unique number for data with certain criteria

    Hello Everyone, I have a sheet and I want to give certain rows a unique number, so when I delete those rows, the number will not be used again. I want to give every row where Column B is the same and Column D is the same and Column L is the same, the same number, so like this: <tbody> Column...
  3. W

    I have two sheets in Excel that both contain data and would like to merge data.

    Hi Guys, I have two sheets in Excel that both contain data. Both pages have a unique column which is labeled 'ItemNumber'. This runs from 100000 through to 106144. Apart from this column, both sheets have different columns with different data. I would consider the 'ItemNumber' to be the unique...
  4. L

    Conditional format non zero unique

    I have a multi-column 4 row table with zero or positive values. In each column I want to highlight the lowest non zero value if it is unique - not quite the same as the lowest unique value, which may not be the lowest value! So must be a Conditional Format formula I am relatively new to Excel...
  5. A

    Generating Sequential Order Numbers

    Greetings oh enlightened Excel Professionals! I humbly seek advice over a number of little issues... I have looked thru a number of the threads and answers already on this site but I do not see anything similar to what I am going to ask you. I want to develop an ordering system for my...
  6. S

    Giving a form a unique ID number

    I have created a form that when printed will be used as a rejection tag for isolating damaged or on-hold parts. Each tag that is printed must have a unique ID number. Is there a way to have excel automatically populate a field, giving each saved/printed tag a unique ID? For example, I open...
  7. A

    Tough question from my friends - Need your help

    Hello All- My friend consulted me a certain task in excel but could not figure out correctly. Here are the requirement; He has the first sheet HERE and here is the input; 1. In column Z, he want to input the machine number 1,2,3,4, etc 2. In column AA, he want to input the sequence number as...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top