I need to compare data from two different notewbooks and store in a third.
Here's my example: Roll - A is a common field in each notebook; I need to
compare data (Notebook-A) Roll B2 and C2 against (Notebook-B)Roll B2 and C2
if not the same store the entire roll in Notebook (C). I hope you understand
my example....Thanks

You might try Chip Pearson's add-in.
http://www.cpearson.com/Zips/Compare.ZIP

--
Please remember to indicate when the post is answered so others can benefit
from it later.


"At Home" wrote:

I need to compare data from two different notewbooks and store in a third.
Here's my example: Roll - A is a common field in each notebook; I need to
compare data (Notebook-A) Roll B2 and C2 against (Notebook-B)Roll B2 and C2
if not the same store the entire roll in Notebook (C). I hope you understand
my example....Thanks

Thanks---- Is there a way to apply conditional formating?

"KC Rippstein" wrote:

You might try Chip Pearson's add-in.
http://www.cpearson.com/Zips/Compare.ZIP

--
Please remember to indicate when the post is answered so others can benefit
from it later.


"At Home" wrote:

I need to compare data from two different notewbooks and store in a third.
Here's my example: Roll - A is a common field in each notebook; I need to
compare data (Notebook-A) Roll B2 and C2 against (Notebook-B)Roll B2 and C2
if not the same store the entire roll in Notebook (C). I hope you understand
my example....Thanks