PDA

View Full Version : Solved: compare worksheets



Shane
07-11-2007, 11:28 PM
I am facing an issue in comparing two worksheets.
The scenario is I have two worksheets 1) Master 2) Sheet2
I would like to compare these two sheets and need a new sheet that contains records which are not common in both the sheets. I do not need records which are same in both sheets.

I have a macro for that and when I rn the same I got wrong output. Pls see sheet ?New? that contains the output of the macro that I ran.

Also attaching the same macro code in txt file.

Pls help ?.

mdmackillop
07-12-2007, 12:08 AM
Have a look at this post (http://www.vbaexpress.com/forum/showthread.php?t=13707)
Instead of deleting, you could cut and paste the rows. I'll check out your own code later.

sujittalukde
07-12-2007, 12:18 AM
Cross posted
http://www.excelforum.com/showthread.php?t=606947

mdmackillop
07-12-2007, 01:08 PM
Hi Shane,
Please read this (http://www.excelguru.ca/node/7).

johnske
07-12-2007, 01:44 PM
Copy ALL data from both sheets to your new sheet and apply special filter to the new sheet to remove duplicates. Example code here (http://xlvba.3.forumer.com/index.php?showtopic=314)

Shane
07-18-2007, 10:54 PM
Thanks guys for ur assistance. n a BIG sorry for cross posting. My only intetion was to get the quick reply as at that time i was in gr8 trouble.
Thanks anyways

Best Regards.