Hello Experts,
I have 2 spreadsheets each containing a column of datas I need to compare
In spreadsheet 1, I have a column of data called ID1. In spreadsheet 2, I have a column of data called ID2.
I defined the data in Spreadsheet 1 as a variable called "ID1", same thing for spreadsheet 2, "ID2".
I need a (Loop+if) function that let me start at the first data in spread sheet one, searches for that data in spread sheet 2. If there is a match, both ID1 and ID2 will be copied to a 3rd spreadsheet, and if there is no match then they will be copied to a 4th spreadsheet. Then same thing all over again at the next data in spread sheet one.
For the sake of easiness, lets assume both ID1 and ID2 will be starting at cell(2,1) in Spreadsheet 1 and 2.
I kind of have an idea of what I am suppose to write but don't know how to put it together
Unless there's a search function that looks for "ID1" in spreadsheet 2 that I don't know about, I am not sure how to write the Loop/If
I don't know if this makes sense to you, I am new to VBA.
Thanks in advance!
Hallet
Bookmarks