I paste a file containing the names of departments and data regarding them
into a worksheet. I run a macro to sort and move each department's data into
their own worksheets. Some departments may not have data moved to their
worksheet (this is a good thing). If their worksheet (i.e. C2) is blank, I
would like the macro to say "Congratulations! You do not have any Negative
reports for this period". I'm having trouble developing the IF statement.

TIA,
Carole O