My wife belongs to a quilting club with several hundred members and each month they require an updated financial members list to be ticked off when they come to meetings. They have an excel (2003) sheet (the master list) than contains all the contact details (surname, first name, address, email, phone, life member status in columns including who is currently paid up (marked with an "x"). The second sheet(meeting list) used at meetings only contains a list of the names of people who have paid and a column to tick off attendance.
The request has a couple of parts:
1: As people pay their annual sub or are life members and their details are updated on the master list can they automatically have their names alphabetically added to the 2 meeting sheets with names A to J and K to Z in each sheet?
2: Is it possible to automatically format the sheets so that when they are printed out the Life members appear on the top of each list and the financial members appear below.
Any constructive suggestions most welcome. tia.
Bookmarks