+ Reply to Thread
Results 1 to 3 of 3

Automatic updating of club membership list

  1. #1
    Registered User
    Join Date
    05-06-2014
    Location
    Palmerston North, New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    2

    Automatic updating of club membership list

    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.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,397

    Re: Automatic updating of club membership list

    Please attach a sample workbook to make dealing with your queries easier.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    05-06-2014
    Location
    Palmerston North, New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Automatic updating of club membership list

    Sample file uploaded. I have just noted the sub paid column has a year (ie 14) not an "x"
    Attached Files Attached Files
    Last edited by plantdoc; 05-07-2014 at 07:08 AM. Reason: data inconsistency

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with automatic chart updating/auto updating today function
    By Tux2424 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-26-2012, 04:45 PM
  2. membership list
    By pedalpowersailing in forum Excel General
    Replies: 3
    Last Post: 08-15-2012, 12:55 PM
  3. trying to produce a membership list
    By rannoch in forum Excel General
    Replies: 2
    Last Post: 10-06-2011, 09:56 AM
  4. Pull out Outlook Distribution List Membership
    By Andrew.Trevayne in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2011, 11:23 PM
  5. [SOLVED] membership list
    By cruncher in forum Excel General
    Replies: 7
    Last Post: 09-26-2005, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1