unique identifiers

  1. J

    Copy/Paste Data from Multiple Workbooks Into One and Adding A Unique Identifier

    I'm new to VBA, but have been trying to teach myself the basics. I was able to copy and paste from multiple workbooks onto on macro-enabled workbook. I need to transfer all data, even duplicated. I want a unique identifier for each of the workbooks that were pasted into my master. Here is my...
  2. D

    How to sort and assign unique id for data in rows in excel

    Dear All, I have large amount of data to sort and to assign id for database bulk upload. It is really hard to manually assign its own id for each data. So if anybody knows ,can you please tell me how to do this in excel. The data is shown as below <tbody> City State email website...
  3. N

    Making a list of unique ID's

    Hi, I am trying to create a formula that will identify unique ID's and pull them into a list in one cell that shows each unique ID separated by semi colons. Data Table <tbody> ID Name 1 John 1 John 1 Max 2 Haviar 3 Jess 3 Ron 3 Ben 4 Marco 4 Marco...
  4. L

    Generating unique ID is excel 2010

    I have a spreadsheet with the following layout <TABLE style="WIDTH: 402pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=536><COLGROUP><COL style="WIDTH: 84pt; mso-width-source: userset; mso-width-alt: 4096" width=112><COL style="WIDTH: 64pt; mso-width-source: userset...
  5. 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...
  6. ClimoC

    unique identifiers needed urgently!!! please help!

    Hey everyone - This one's rattling my brain knackered - so I thought I'd repost this in clearer english to try and bring about an answer... What I need is for column X in Sheet2! to have a number plopped in it everytime this macro is run. The hard part has been done - it already identifies the...
  7. ClimoC

    Very Simple but I can't work it out! - Sequential Unique Identifiers

    Hello... I have this code atm: Range("D4").Select Selection.Copy Sheets("Sheet2").Select Range("E:E").Select Selection.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, Lookat _ :=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _...
  8. R

    Sumproduct with a twist

    Hi all, I have a sumproduct formula in a cell that returns a count of the number of times several columns satisfy certain conditions. One column referred to in the formula contains a unique identifier. How can I tweak the sumproduct formula so that it will ignore any repeat instances in...

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