Hi!

I am trying to produce a summary worksheet that automatically only contains
rows from another worksheet that meet a certain criteria.
I have been trying to write an "if" statement that only copies those cell
that meet the criteria but if they don't, hide the row.

This is a constant recurring task for me, so I don't want to have to
manually run macros and/or filters every time I want to look at the summary
sheet.

This means every cell must have an "if" formula.

I have seen a number of VBA scripts (in other messages) to hide rows but can
I enter them as part of a formula?

I hope I have explained this properly. Thanks for any help.

Sally.