PDA

View Full Version : Compare two worksheets and give the difference as result



hakunamatata
09-21-2012, 11:43 AM
Hello Everybody
I want to compare the two worksheets and after comparison it gives the difference. For the sake of example workbook is attached with this thread.Using vba macro.

hakunamatata
09-22-2012, 07:03 AM
Somebody will help me in this regard, need it badly.

hakunamatata
09-22-2012, 09:28 AM
I think in my last attached workbook the problem was not clearly defined therefore i attach the workbook again.

parttime_guy
09-27-2012, 07:58 PM
Hi Hakunamatata,

Attached is a solution using vlookup - plz test... by pasting your relevant information directly into the results worksheet in flap "Data A" and "Data B" respectively.

I hope this solution works for you.

Regards