I want a separate worksheet in Excel to build an error report from another worksheet in the same workbook. The data would be a list of employee positions such as full time, part time, temps, seasonal etc...and ONLY full time positions should have insurance costs listed in a particular field. I want the report to search the data and if it finds insurance expense in that field for any other position than a full time position, copy the entire row of information and add it to the error list. The problem I am having is having the report build the list so that there are no empty rows on the list. I don't know a simple way with a formula to do this and assume I need a macro to build it so that as it finds the data, it puts it on the next available line on the report. Once I have a macro to do it, I'd like to set up a button and assign the macro to it so I can run it when I want. I have attached a very simple sample.