Compare Sheets Find Missing Data

Hello and thank you in advance for your help.

I have an excel workbook that has a master sheet that keeps track of items and there location that constantly changes and another sheet that keeps track of past locations and does not change. Currently when a record is changed in the master sheet the row is manually copied and pasted into the 2nd sheet. I would like a macro that would find items in the master sheet that are not in the 2nd sheet and copy them to the 2nd sheet when records change.

Example:
Day1 Workbook appears
Master Sheet 2
Equip # Location Equip # Location
1 shop 1 shop
2 field 1 2 field 1

Day2 Workbook changes
Master Sheet 2
Equip # Location Equip # Location
1 field 2 1 shop
2 field 3 2 field 1
1 field 2
2 field 3

The part I am struggling with is finding rows that appear in the master sheet but not anywhere in sheet 2. There are 6 columns in each row. I just need to be pointed in the right direction. Thank you.

Thank you for the quick reply however that will not work. I am not very good at explaining but the master list is use to be able to find where equipment is at any given time. The second sheet is used to keep track of where equipment has been so the records cannot be deleted.

I think I could solve it I just don't know how to compare a row in the master sheet with all of the rows in the 2nd sheet regardless of order similar to ISERROR(MATCH(A1,$B:$B,0)) but with vba and all 6 columns.

Maybe it can't be done.

Sample.xlsx

I should have done that right a way sorry. You would not have to compare every column only Job Assignment, Equip #, and Date Out are nessessary. I was originaly thinking of some sort of series of If statements but I am pretty new at this.

Sample2.xlsm

Again I'm sorry. I have attached a new sample. The data contains many entries in sortable tables and expands as tools are added I think it would be too large. I found a macro that finds matching rows I modified it to search the columns I need. Currently it just prints the rows that match.

I think the following code is close. I think it finds unmatched rows but it copies and pastes every row instead of just the ones that don't match. If anyone has any ideas let me know.

Please Login or Register  to view this content.

Thank you all for your help I found a solution however it does not work in Excel 2003. If anyone knows off the top of their head why that would be great else I think I figure it out. Here is the code.

HTML Code: 

Thank you all for your help I found a solution however it does not work in Excel 2003. If anyone knows off the top of their head why that would be great else I think I figure it out. Here is the code.

HTML Code: 

That works great, Thank You.