Excel 2007 : How to compare data in two tables?

**learner6** · 04-02-2009, 11:55 AM

Dear Friends,

How can I compare data and get the result like attached file?

**JBeaucaire** · 04-02-2009, 09:58 PM

The following macro will do what you'd like. Run it on the attached sheet, or install it into your own. It should work with any length sets of data.

Please Login or Register  to view this content.

**learner6** · 04-03-2009, 12:04 PM

Originally Posted by JBeaucaire

or install it into your own.

Dear Friend,

It is marvelous. Working so nice. I would like to know how to install it on my own form?

Regards,

Learner6

**JBeaucaire** · 04-03-2009, 03:01 PM

Press Alt-F11 to open the VBEditor
Click Insert > Module
Paste in the code provided above
Press Alt-F11 to close the editor
Save your sheet before running it the first time...

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]

**learner6** · 04-05-2009, 12:59 AM

Originally Posted by JBeaucaire

Press Alt-F11 to open the VBEditor
Click Insert > Module
Paste in the code provided above
Press Alt-F11 to close the editor
Save your sheet before running it the first time...

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]

Thanks a lot it is marvelous. I have one another problem. I hope you may help me to solve the problem. The thread link is:

http://www.excelforum.com/excel-2007...as-result.html

Thanks once again for the help.