LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Comparing two columns in two different worksheet.

I have two worksheets (i.e. abc & def ) in same workbook. Only one column
in the two workbooks (i.e column B in abc worksheet and column C in def
worksheet) containing common data. I want excel to compare each cell in
column B with each cell in column C and if it is identical, Excel should
copy all corresponding data in same raw and past them in the corresponding
raw inr the other sheet.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing columns Dave T Excel Worksheet Functions 1 May 23rd 09 10:27 AM
Comparing two columns of information with 2 new columns of informa cbuck Excel Discussion (Misc queries) 1 January 16th 07 09:49 PM
Comparing 2 columns if they are the same Faio Excel Worksheet Functions 4 November 15th 05 10:18 AM
comparing two columns? steve g via OfficeKB.com Excel Discussion (Misc queries) 1 April 30th 05 04:53 AM
Comparing Two Columns? PattyB Excel Programming 4 October 11th 04 02:36 PM


All times are GMT +1. The time now is 10:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"