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