Spreadsheet: 167331d1341952482-match-two-columns-on-two-different-sheets-then-copy-row-otherwise-move-to-next-row-matchdata-w1-cola-moverowonmatch-w2-cola-wallstcheater-ef844253-sdg10
Sheet: Instructions

Sheet1 | A | B | C | D | E | F | G | H
1 | idValue | TradingExchange | tradingExchangeCode | countryCode | IDCode | codeAgg | focusLevel | level |  | MatchData w1 colA moverowonmatch w2 colA - wallstcheater - EF844253 - SDG10.xls
2 | A | NYSE | XNYS | US | 45203010 | 45203010 | No | 4 |  | Join Date: 07-10-2012Location: London, England MS-Off Ver: Excel 2003Posts: 1Post Thanks / Like ::::
3 | AAON | NASDAQ | XNAS | US | 20102010 | 20102010 | No | 4 |  | Match Two Columns on Two Different Sheets, Then [NAME], Otherwise Move to Next Row
4 | AAP | NYSE | XNYS | US | 25504050 | 25504050 | No | 4 |  | http://www.excelforum.com/excel-general/844253-match-two-columns-on-two-different-sheets-then-copy-row-otherwise-move-to-next-row.html
5 | AAPL | NASDAQ | XNAS | US | 45202010 | 45202010 | No | 4 |  | Hi Everybody,
6 | AAUKY | NASDAQ | XNAS | US | #N/A | #N/A | No | 4 |  | I am trying to match two column of cells on two different sheets,
7 | AAWW | NASDAQ | XNAS | US | 20301010 | 20301010 | No | 4 |  | if they match, it should copy the entire row to sheet2.
8 | AB | NYSE | XNYS | US | #N/A | #N/A | No | 4 |  | 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).
9 | [NAME] | NASDAQ | XNAS | US | 35101010 | 35101010 | No | 4 |  | Otherwise, move to the next row.
10 | ABB | NYSE | XNYS | US | #N/A | #N/A | No | 4 |  | I guess I'm having problems because I can't figure out how to scan the entire column for a matching stock symbol.
11 | ABC | NYSE | XNYS | US | 35102010 | 35102010 | No | 4 |  | The rows may or may not match, but that doesn't mean an exact match doesn't exist.
12 | ABCO | NASDAQ | XNAS | US | 20202020 | 20202020 | No | 4 |  | In the example I attached, [NAME] is in the 7th row in sheet 1, but in the 8th row on sheet2.
13 | ABFS | NASDAQ | XNAS | US | 20304020 | 20304020 | No | 4 |  | (I want the data on sheet 1 to be moved to sheet 2).
14 | ABG | NYSE | XNYS | US | 25504050 | 25504050 | No | 4 |  | They wouldn't match up exactly when going row-by-row,
15 | ABM | NYSE | XNYS | US | 20201050 | 20201050 | No | 4 |  | but that doesn't mean there isn't an AAWW match to be made.
16 | ABMD | NASDAQ | XNAS | US | 35101010 | 35101010 | No | 4 |  | [NAME] is in 12th row in sheet 1, but in the 9th row on sheet 2.
17 | ABT | NYSE | XNYS | US | 35202010 | 35202010 | No | 4 |  | So, I'm stuck on trying to figure out how to get the data from sheet 1 to sheet 2.
18 | ABV | NYSE | XNYS | US | #N/A | #N/A | No | 4 |  | My solution isn't smart enough to know the matching symbol are really available in the column somewhere.
19 | ABVT | NYSE | XNYS | US | 50101010 | 50101010 | No | 4 |  | I attached an example of what I am trying to do. Any suggestions (or code samples) would be greatly appreciated.
20 | ABX | NYSE | XNYS | US | #N/A | #N/A | No | 4 |  | Thanks
Sheet1 | A
1 | idValue | 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).
2 | A | Otherwise, move to the next row.
3 | AAON | I guess I'm having problems because I can't figure out how to scan the entire column for a matching stock symbol.
4 | AAP | The rows may or may not match, but that doesn't mean an exact match doesn't exist.
5 | AAPL | In the example I attached, [NAME] is in the 7th row in sheet 1, but in the 8th row on sheet2.
6 | AAWW | (I want the data on sheet 1 to be moved to sheet 2).
7 | [NAME] | They wouldn't match up exactly when going row-by-row,
8 | ABC | but that doesn't mean there isn't an AAWW match to be made.
9 | ABCO | [NAME] is in 12th row in sheet 1, but in the 9th row on sheet 2.
10 | ABFS | So, I'm stuck on trying to figure out how to get the data from sheet 1 to sheet 2.
11 | ABG
12 | ABM
13 | ABMD
14 | ABT
15 | ABVT
16 | ACI