ids

Hello all, I've been working to transition an access database to a new datasource. Previously, the inputs were copied and pasted from a query tool window in to an excel macro workbook, where the Unique ID's were treated as a "General" number, and the macro compiled all the results and saved...

Hi Everyone, In Sheet "Data" Column A I have Client Id's In Sheet Control, Column H I have a list of Client Ids, I need a macro that can go down "Data" Column A. Find the last of each client ids and instert a row and put the client Id Number into that Row column A So if I have 6 Client Id's...

Hi, I have product names in A column while product IDs in columns from B-K. I need to put product IDs under product names in Column A in excel. Is there a formula to do so? I am confused.

I have a column where email ids are typed. now although the email ids filled may be bogus, I just need to validate that there is a @ and . in the cell So if the @ and one dot is missing from the cell the entry should be rejected and an error message pop ( like we have in data validation )

I work in a program that tracks equipment. There are two categories of equipment, Main and Sub. Not all Main will have a Sub attached to it, but when there is a Sub attached it has the same Id as the Main equipment. The Main equip has the project number, task number, work date, start, stop time...

Long time lurker, first time poster. I have been struggling with this and hoping you all can help me out. I apologies if my explanations is really clear, it is kinda complex. https://imgur.com/a/N4lon So i have the spreadsheet above where there are the IDs in column F ( the are the family IDs)...

Hello and thankyou for any attention my post may receive. I have a db with numerous objects - three of which are tblMain, frmCapture,frmReadOnly. When the user opens frmReadOnly I would like the from to not only populate withthe appropriate information according to the ID but also with...

Hello, My scouring of previous posts somehow has not turned up something close to what I am looking for. Thanks in advance for any guidance you can please lend. A simplified version: I have a 'Master' worksheet that has IDs listed in column A, starting at row 2. In 'Sheet2' of the same...

Hello all! I have a question regarding VLOOKUp. I have a list of IDs and Values. In a set of data I need to get the IDs with only ONE occurrence. Here is the Sample Look up table ID VALUE 1 a 2 b 2 c 4 d 4 e 5 f...

I have two sheets of data, where column A of both sheets have a unique ID. I would like to see if any of the unique ID's in sheet two are also in sheet one. I've tried VLookups, but this only picks those up where they match exactly on the same row number. My issue is, the Unique ID's my fall on...

Hey Guys, I currently receive a CSV report in excel that contains "site ID's". Example of these Site ID's are: K7, CK055, CK056, NOV07, etc, etc. The problem is that all the site ID's that contain NOVxx are turned into a date. So, for instance, site ID NOVO7 is changed to 11/7/2018 and is...

Hey guys, I was wondering how would go about doing this: I have a data set of unique ID's and two date columns. Ex. <tbody> Unique ID Start Date End Date 1 1/10/2000 1/15/2000 1 1/16/2000 1/20/2000 1 1/21/2000 1/23/2000 1 2/1/2000 2/4/2000 1 2/5/2000 2/8/2000 2 2/2/2000 2/7/2000...

Hello, I have a sheet with some data that populate based on some formulas and i want to create a column that will be used for unique IDs (ideally incrementing) everytime new data is entered. The IDs should be created thus: =if(a1=“51321”,(char84)& “the auto generated number”...

I have a workbook that I don't want anyone else to print except the supervisors. I have a list of those supervisor's ID's in a range on a tab in the workbook. All of our users have to sign into the computer using their ID. I am looking for some code that will compare the user sign on to the...

I have a long list (several thousand) of record ids - see below. Each record id is associated to a name of an individual who belong to "n" groups for very good reasons. Hence a record ID can be replicated many times because the individuals belong to many groups. I wish to create a unique key...

Hello, I have an excel sheet with two columns. The first column has several hundred product ID's that have been utilized and a column with the date they were utilized. I have another excel sheet that has three columns. In the first column is the list of all product ID's that we need to identify...

Hello, My goal is to show the IDs in column C if: The IDs in Column E, have a corresponding date in Column D that matches Cell C3. My formula does that but I want to add a kind of validation so only the IDs appearing in Column C has a match in Column G. In my example below, 1234 should not...

Hi, I have unique IDs in column A of "tab 1" with the same IDs in column A of "tab 2". What I want to do is within Column E of "tab 1," is the following: 1. I want to check the ID in column A, and then if the value in the heading of "tab 1" called "topic" = "Ice Cream Van [1]" and if heading...

I have a data in two different worksheets/tables that I am trying to match up the unique IDs and dates of service and return the corresponding claim number. One table lists a specific date in one column for unique IDs and the other table lists a date range in two columns for the unique IDs...

Hi, I am trying to create a web connection to a website that has a drop down with a list of plan id's. The drop down list on the website refreshes several times a week and i want to pass a parameter that selects the plan id at the very top of the drop down list. Unfortunately the plan id's...