hi everyone
would like some help with this.
have column a being an id and column b a date on multiple sheets.
if there is a match anywhere in the sheets then the macros would copy the entire row and place the two lines of data next to one another in the same row on a new sheet.

ex

sheet 1

mm2200 2/4/14 yes

sheet 2

mm2200 2/4/14 no

sheet 3

mm2200 2/4/14 yes mm2200 2/4/14 no


thanks!!