Date based formula, ignore blank cells, formula to copy details to another sheet

[Naomi2701]

I have 'volunteered' to create a workbook, however the requests keep getting bigger and the task is now significantly monopolising my workload. I'm hoping that your Excel gurus can streamline my efforts and I can finalise the sheets asap.

I need to determine what reporting is outstanding, and create a central Admin sheet that will show any data that requires attention. (If the end date (F11), is before today data can be reported. If not, staff need to be aware that the line is not yet finalised. Once the end date has passed, I need details to be copied to a separate sheet to give staff a central list of all required data entry)

1. I have successfully formulated the first step of determining if a date is before/ after today =IF(F11< TODAY(),"To be entered","Not Complete")
2. I have created another step to determine if a second date is before/ after the primary date =IF(F11> L11,"Ongoing","Complete")
   
3. I am now getting a result (False, True respectively) for my blank cells- can I edit these formulas so that only populated cells prompt a result?
4. Once completed, is it possible to request that the row of a specific result (ie "To be entered") is copied to a separate sheet?
   

I hope that this all makes sense!! I feel that I am getting lost in the details and missing something really simple!

Thanks for any help!

 

[frank_AL]

I can help with question 3. Change the Formulas as follows:

=IF(ISBLANK(F11),"",IF(F11< TODAY(),"To be entered","Not Complete"))

=IF(ISBLANK(F11,"",IF(F11> L11,"Ongoing","Complete"))

Other experts on this Forum might be able to create a Formula to copy data to a separate sheet.
I could build a simple VBA code module that could accomplish that if you would be comfortable with that as a solution.