Pulling data to new spreadsheet based on multiple criteria

I have a large spreadsheet with multiple columns. In 12 of these columns, we are completing whether we have the data or it is missing. I want to create a new spread sheet that pulls only the rows that are missing data. If any of the 12 fields are missing, I want to pull all 12 fields along with a few other fields to a new spreadsheet. Does anyone have any ideas how I can do this. I do not know Macro codes and an if statement is too long. I am working in 2003 Excel.

Thank you

Hi,

Would you please attach a sample of the workbook?

Thanks