| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare Rows in Sheet 1 & Sheet2
I need a bit of code please to compare rows in sheet1(columns B,C,D,E & G
only as column F is not consistant) against rows in sheet 2. SHEET1 A B C D E F G 28 6/03/2006 24/03/2006 100.00% Holiday Fred Bloggs (Exists in Sheet2)) 29 20/02/2006 24/02/2006 100.00% Holiday Holiday John Smith (Exists in Sheet2) 30 24/02/2006 24/02/2006 100.00% Holiday Holiday Ian Brown (Does not exist in Sheet2 as column G is different) SHEET2 A B C D E F G 28 6/03/2006 24/03/2006 100.00% Holiday Holiday Fred Bloggs 29 20/02/2006 24/02/2006 100.00% Holiday Holiday John Smith 30 24/02/2006 24/02/2006 100.00% Holiday Holiday Ian Grey If row exists in sheet2 i don't want to do anything BUT if row does not exists i'd like to copy the row from sheet1 and paste it into the next available row in Sheet2 Thanks MHD143 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| Compare and Update elements from Sheet1 with Sheet2 | New Users to Excel | |||
| how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
| Compare values on sheet 1 to values on sheet2 | Excel Worksheet Functions | |||
| Trying to find a value from one sheet, on another, then compare rows | Excel Programming | |||
Threaded Mode
