|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
macro for comparing data from 3 columns and pasting into another worksheet
Hi,
I want to write a macro which compares two sheets (say sheet 1 and sheet 2) as following : Sheet1 A B C D E F G H I J K L M 2 4 5 Y F D 3 1 G S 2 4 5 1 3 7 U F G 2 6 J K L 3 5 2 6 5 N G S 3 1 G R 9 0 1 Sheet2 A B C D E F G H I J K L M 2 4 4 Y F D 3 3 G S 8 4 5 1 3 7 U F G 2 6 J K L 3 5 2 6 1 N G S 3 1 P Q 9 0 1 It checks from sheet 1, one by one each row if in any row of sheet 2 has matching entry in column A, B, F and G (same as that of sheet 1), it copies the whole row of sheet 1 into sheet 3 and of sheet 2 into sheet 4. i am a researcher and need it badly for data analysis...lottttttttt many thanks in advance.... |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Headers in Same Worksheet | Tom | Excel | 3 | 05-18-2011 03:22 PM |
Compare data in different columns in an Excel sheet | kgfendi | Excel | 5 | 05-16-2009 05:42 PM |
Comparing Data | leroytrolley | Excel | 1 | 08-09-2008 08:34 PM |
TRANSFER DATA TO NEW WORKSHEET | BOBN | Excel | 0 | 11-08-2007 10:34 PM |
click a cell to go to a worksheet | victor | Excel | 0 | 10-27-2006 02:57 PM |