Hi Everybody,
I am trying to match two column of cells on two different sheets, if they match, it should copy the entire row to sheet2.
So, if A2:sheet1 = A2:sheet2, then copy the date in sheet1:a2 to sheet 2:a2 (and fill in the rest of the row). Otherwise, move to the next row.
I guess I'm having problems because I can't figure out how to scan the entire column for a matching stock symbol. The rows may or may not match, but that doesn't mean an exact match doesn't exist.
In the example I attached, AAWW is in the 7th row in sheet 1, but in the 8th row on sheet2. (I want the data on sheet 1 to be moved to sheet 2). They wouldn't match up exactly when going row-by-row, but that doesn't mean there isn't an AAWW match to be made. Likewise ABCO is in 12th row in sheet 1, but in the 9th row on sheet 2. So, I'm stuck on trying to figure out how to get the data from sheet 1 to sheet 2.
My solution isn't smart enough to know the matching symbol are really available in the column somewhere.
I attached an example of what I am trying to do. Any suggestions (or code samples) would be greatly appreciated.
Thanks
Bookmarks