Worksheet comparisons

[mdwilliams26]

I'm trying to run an inventory comparison between two worksheet
containing: Room #, Assett #, and Description

I would like to create a new worksheet that contains all of the item
in worksheet A that were not in worksheet B. Due to obviou
differences in description and even Room #, I probably will not be abl
to include them in the comparison, but how can I do this compariso
with just the asset #'s.
Any help would be greatly appreciated. Thank

 

[Frank Kabel]

Hi
see: http://www.cpearson.com/excel/duplicat.htm#InOneNotOther

After using this approach you can use 'Data -Filter - Advanced Filter'
to copy these records