Hi all..... While I do know a little about Excel, I am hoping the Guru's here can help this comparable novice. This is what I am trying to do and am hoping someone here can help me. Each month I get an inventory report (excel file - lets call it "spareinv") listing the asset # & serial number of the equipment I "should have". Let's say the asset number is in "B" column and serial number is in "C" column. I have come up with a way to do a "physical" inventory each month with a bar code scanner in which I scan the asset tag and serial number which is on the equipment in bar code format. Currently I scan these to another excel spreadsheet (let's call this one "Physical"). I copy and paste the info from "physical" sheet into the bottom of the "spareinv" sheet using the same columns. Then I run a conditional format ("countif" formula) on column "B" (asset#) to look for duplicate assets (formatting duplicates yellow) and another conditional format, also "countif" on the "C" (serial#) formatting duplicates green. Obviously, the ones that match (colored) have been verified physically, the unmatched ones have not been physically verified. Doing both columns allows me to check for database input errors. In a nutshell, I know there is an easier way to do this, I just can't figure it out. For instance I know I don't need to do the cut and paste between the two worksheets. What I would like is a formula or template to look at both sheets, take the matches and paste them in another spreadsheet ("verified"), and paste the unmatched (unverified") in yet another spreadsheet. Anyone have any thoughts? Any help you can give would be VERY appreciated!! THANK YOU! Sorry this is so long!