My workbook contains membership records for a club. The main worksheet is a
register (database) containing all the relevant details of each membership,
including whether the current subscription has been paid.

When I need to print a list of, say, all the members who have not paid yet
OR all the members who do not have email addresses, I do it the long way - by
sorting the register worksheet on the appropriate column and then copying the
required records to to a new worksheet. I then modify the worksheet to
display what is needed and print it. Then I have to sort the register back
into main key order.

Is there any shorter method of doing this, perhaps by inserting an array
formula into a new worksheet? I could probably write a VBA routine to do
this, but as I am still a beginner with VBA I would prefer to find an
existing solution.