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 worksheets


Hi

I have two worksheets, which both have similar data.

I need to compare sheet1 to sheet2 and the data that in sheet1 that is
not in sheet2 place into sheet3.

e.g.

sht1 sht2 sheet3
aaa aaa ddd
bbb bbb
ccc ccc
ddd eee

Please help!

I tried the compare macro in forum, but error occurs and cannot debug!


--
unsworthcl
------------------------------------------------------------------------
unsworthcl's Profile: http://www.excelforum.com/member.php...o&userid=23946
View this thread: http://www.excelforum.com/showthread...hreadid=375745

 
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 two worksheets Jules Excel Worksheet Functions 1 October 5th 07 10:32 PM
Comparing 5 worksheets thewildleo Excel Worksheet Functions 0 July 27th 06 09:47 AM
Comparing Two Worksheets for changes Jugglertwo Excel Discussion (Misc queries) 1 December 7th 05 08:56 PM
Comparing Across Worksheets Dave F.[_2_] Excel Programming 0 March 4th 04 11:56 PM
Comparing 2 worksheets Smoky2010 Excel Programming 1 February 3rd 04 01:50 PM


All times are GMT +1. The time now is 07:13 AM.

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"