I have a workbook that my company uses to do bid on large construction projects. One worksheet is used to gather the information and calculate the price for each room in a project. We have been copying and pasting this data to a "Report" worksheet. I have found a couple of treads about coping data based on a criteria on the forum, but they use a form control to start the copy/paste action. Is it possible to start the code with an IF/Then statement referring to a cell value for each room? In other words if a room total is 0, it's information is not copy/pasted to the Report Worksheet.