unique id

I have an employee roster where I am doing a Vlookup using their employee ID from another sheet which has their ID & multiple quiz scores per employee. I'm trying to figure out how to bring over each employee's highest quiz score so that each employee shows the most accurate score. The second...

I need to create a unique ID for tracking stuff and I've used the following to do it for now, but it's not ideal as I need to scale this ability to others as well. Current solution: 1) Open spreadsheet, insert a new column and find First Name(E2) and Last Name(D2) fields and adjust the following...

Hi all, I have a workbook with multiple sheets (unfortunately due to vast amount of data I have to keep sheets separate). The only unique column is the ID column in column A between sheets. My goal is to be able to filter sheet 1 (the master sheet) based on columns B onwards: the IDs that are...

Hi all, I've scoured the forum for a solution to this. I know there are various threads that are related but either my VBA skills aren't quite good enough or they don't quite match my requirements. basally I have the following script: Sub AddRow() Dim sht As Worksheet Dim LastRow As Long Set...

Greetings, I'm grateful for finding the Worksheet Change code below on this forum. After a small modification per my needs, it successfully generates a unique ID in column AB whenever a new record is entered in column A. I would like to modify the code so that the current year and a hyphen...

Hi! So here's a broad description of what I want to do: Given values in column B [1, 6, 3, 18... -5, -6, -22...] I want to write a script that gives a unique tag in column C next to each pair where a positive and negative value will cancel out. EXAMPLE: B | C 3 | 1 7 | 4 | 1 | 2 -3 | 1...

I am trying to use a forumla to look at the value in column b then create a unique id in column a based off of that value. In the table below I have a 3 digit value (in column B) that may be repeated any given number of times and if so I want the corresponding text in column "A" to equal that...

Hello, I have about 6 Excel files full or email address. 160K rows. The list looks like this: <tbody> date Order Sale Email I NEED UNIQUE ID 1/2/2008 1 $2 j@j.com 2234 1/2/2008 2 $2 wo@.com 2235 1/2/2008 3 $2 j@j.com 2234 1/2/2008 4 $2 sam@cool.com 2236 </tbody>

Hi, I am creating a User form to save the difference departments discretion numbers, here i am facing a problem that in Combo box 10 i am having list of departments and combo box 11 is having departments sanctioning authorities now i have to generate the next discretion number based on the...

I have a list of webpages contacting different domain pages!!! I want to pick a single webpage of each domains!!!! Please help ! This is an example list: And I need this as .....

Hi Everyone, I am looking for help creating a macro that can delete revenue values that occur outside of a date range that is contained in two separate columns. The spreadsheet is around 1100 rows long and around 40 columns wide (i.e. it is displaying 3 years worth of revenue data broken up by...

I am a pharmacy student in serious need of help for my internship. I need a macro/vba code that auto generates when there is cell content in a row of a worksheet. this number is going to be an invoice number. I current have a 'masterfile' that records all finalized orders for each facility...

I am having a problem coming up with a MAX function that will return the last date in a sequence. I have tried the =MAX(IF($A$n:$A$n=An,$B$n:$B$n)) function, although it returns the MAX date in the entire list rather than just the highest number date for the given unique ID number. For...

Hi Everyone, I am very new to excel vba code, macro and vba userform. I was able to device my first vba userform file by this site's help that's why I registered. Now I have a new project that needs another vba, macro based with vba userform database. I need a userform that can compile data...

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...

Hi Everyone, Just wanting some suggestions before I go ahead and create anything. I am needing to create a template that is basically a data entry form. There are a limited number of drop downs and other data fields. What I would like to know before I begin is: - Can I add the template to the...

Hey guys, I have a list of email addresses in column A and i have a unique identifier in column B that corresponds to the email address in column A, in a perfect world there would be one email address that corresponds to one unique identifier. I need to know when i have an email address that...

We have our new employees fill out a form with name, address, tax info, etc. each week. (They all do it at the same time.) I then get 20 PDFs and export all the data to a CSV. We now want to import that CSV into our payroll software. However, the payroll software requires a unique ID for each...

I am a novice when it comes to making macros so I am in desperate need of help. I have two worksheets, one with data that will be updated with new data everyday and the other, a template that the data needs to fill in by each row accordingly. However the template needs to be a copy of the unique...

Hi there, I'm comparing data from two different sources and need an efficient way to do it. I have one Excel workbook with two sheets - RAS EpSelect 0101-0106 and RAS HCP 0101-0106. Both worksheets have mostly the same data but is distributed over different columns. The data I'm using has...