How to check if a unique ID exists in another sheet,and if not, bring record to new sheet

**avib** · 07-27-2015, 12:54 PM

Essentially, I'm trying to merge info from one spreadsheet into another. The Destination sheet has some of the records (with matching unique IDs) form the Source, but not all. I'd like to check if the Unique ID exists in the Destination array, and if not, bring parts of the record from the Source to the Destination sheet. My first thought was to create a third sheet, where I'd test whether there's a match, and if not, display the cell there, but I ran into some circular referencing issues. Essentially, I'm updating one sheet (destination) with data/records from another (source) - I've figured out how to update records with matching IDs, thanks to the help of this forum, but am stuck bringing in those records who's IDs do not yet exist in the destinationVLOOKUP_Test_Book.xlsx
Thanks for any help!

**nigelbloomy** · 07-27-2015, 12:59 PM

I created a new column in the source sheet and put in the following formula:

Please Login or Register  to view this content.

Employee ID's that exist in the source sheet but not in the destination list are shown as "New" and the ones with a match already are shown as "Exists". Does that help?

**avib** · 07-27-2015, 01:19 PM

This does help, as it lets me know which records exist (and therefore won't be copied to the destination) and which are new (and therefore will be copied to the destination) but now I'm just not sure how to best transfer the New data to the destination. I guess I can filter out the Exists records, then simply copy and paste the data I want, but I'm guessing there's a better way to do so with functions.

Thank you for your help though!

**nigelbloomy** · 07-27-2015, 01:50 PM

I believe VBA is the only way to fully automate what you are looking for. This code works if you add in a DOB column B in your sourceSheet. That way the fields all line up when they are copied and pasted to the destination sheet.

Please Login or Register  to view this content.

**avib** · 07-27-2015, 01:57 PM

Cool, I'll try this out and see if I can get it to work with my project. Thank you for helping out

**newdoverman** · 07-27-2015, 04:27 PM

I have combined both worksheets into one taking the missing values from the Source worksheet and combining them with the values in the Destination worksheet.

There is a helper column (A) on both of your existing worksheets that has consecutive numbering for the values to be brought forward to the Combination worksheet.

How to check if a unique ID exists in another sheet,and if not, bring record to new sheet

LinkBack

Thread Tools

Rate This Thread

Display

How to check if a unique ID exists in another sheet,and if not, bring record to new sheet

Re: How to check if a unique ID exists in another sheet,and if not, bring record to new sh

Re: How to check if a unique ID exists in another sheet,and if not, bring record to new sh

Re: How to check if a unique ID exists in another sheet,and if not, bring record to new sh

Re: How to check if a unique ID exists in another sheet,and if not, bring record to new sh

Re: How to check if a unique ID exists in another sheet,and if not, bring record to new sh

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to check if a name in one sheet exists in other sheet.

[SOLVED] Check to see if sheet exists

VBA/Macro help needed for check sheet name is exists if not activate another sheet.

Check if sheet exists in another workbook

Check to see if a sheet exists

Check if sheet exists problem

[SOLVED] check if the sheet/tag exists

[SOLVED] How to check from VBA if sheet exists?

Bookmarks

Bookmarks

Posting Permissions