First I want to say thank you, since I am new to the world of VBA / Macros. I currently have a workbook containing 3 worksheets named "Baseline", "New", and "Summary". Each month I will recieve a report and add it to this workbook and name it "New". All worksheets are laidout with the same column headers. I would like to compare rows in the "New" sheet with the "Baseline". I basically need to develop an AND IF logic in a macro to compare criteria by row across sheets. So if a row in sheet "New" does not match values for columns "A" and "O" in sheet "Baseline", I would like to copy and paste the non-matching row from sheet "New" to the first blank row in both the "Summary" and "Baseline" sheet. Column "A" is a numerical ID and column "O" is a date. After the rows are copied over, I want to automatically sort by date (column "O") from newest to oldest in both sheets "New" and "Baseline". Then finally delete the "New" sheet. Your help is much appreciated!