I have a workbook that has information in it that i want it to look at a column (DREC) and if it is blank then copy and paste it onto another sheet Called "Report". The "Report" sheet has headers just like the first sheet, so it would have to paste them to Row 3. I would also need a macro to clear the sheet when done. Ie it would clear Reports from row 3 down.

Thank you for any help i have tried to google it but can't find anything.

Columns

Who Tracking# Name Order# What Vol RF DReq DREV DREC