Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-11-2009, 09:44 AM
ashukla ashukla is offline macro for comparing data from 3 columns and pasting into another worksheet Windows XP macro for comparing data from 3 columns and pasting into another worksheet Office 2007
Novice
macro for comparing data from 3 columns and pasting into another worksheet
 
Join Date: Jun 2009
Posts: 1
ashukla is on a distinguished road
Default 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....
Reply With Quote
  #2  
Old 06-24-2009, 05:01 PM
zyzzyva57 zyzzyva57 is offline macro for comparing data from 3 columns and pasting into another worksheet Windows 7 32bit macro for comparing data from 3 columns and pasting into another worksheet Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

Does this help to start and maybe modify to fit your particular needs

Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Headers in Same Worksheet Tom Excel 3 05-18-2011 03:22 PM
macro for comparing data from 3 columns and pasting into another worksheet Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM
macro for comparing data from 3 columns and pasting into another worksheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft