Excel 2003 VBA mismatch for stocktake

Hello, I've already found most of what I'm looking for from this super post:

Please Login or Register  to view this content.

But I'm trying to get the rest of the row of the mismatched cells to be displayed in Sheet3 and being new to this I'm not sure where to start.

This spreadsheet is for a library stocktake.
Sheet1 is the book barcodes plus title details exported from the catalogue.
Sheet2 is a list of scanned barcodes taken from books on the shelf.
Sheet3 is the mismatch data (missing stock).

Any help would be much appreciated.

Try code such as the following. I made a couple of changes to the code that resided in your workbook to add the additional columns, and to make the code run faster.

Please Login or Register  to view this content.

Many thanks, BigBas.

That's fixed it. Now I just need to learn how to do this myself!

Not a problem. I'm glad I could help.