View original (French)

Database - member management association

diabete47 -  
Raymond PENTIER Posted messages 58219 Registration date   Status Contributor Last intervention   -
Hello

I am looking to create an Excel workbook to facilitate the management of the members of my association.

Ideally, I would like to enter the data in the form of a form with the possibility of searching for a member by their membership number to modify it only if needed during the renewal of their subscription. And have the option to select from 3 options to copy the data to other worksheets (depending on the checked options).

Basically, something to avoid what we have been forced to do for too long, which is time-consuming for volunteers.

Thank you in advance

Jean Arnaud Elissalde

3 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    I'm not sure I understood everything, but I'm offering you your binder with a search form and a dynamic update one that are linked together.

    https://www.cjoint.com/c/CIEqwnW42o5

    Since I couldn't find a way to detect the sheets to modify, I've added checkboxes for each one: if you have a simpler rule, let me know.

    Be careful, I've corrected some section names that were not identical across all sheets, and since there needs to be an equivalence because their position is different, the name must be the same.

    Happy testing.
    --
    Always zen
    Perfection is achieved not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
    4
    1. diabete47
       
      Thank you for your response and for your suggestion: I will try it out and will get back to you with my feedback ;-)

      PS: I am currently unable to open your file (I am working with Excel 2013 // Windows 8)
      0
    2. gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
       
      I work with Excel 2013 // Windows 8)

      It should normally work: which Internet Explorer 10 browser?
      - click on the link
      - in the new tab click on gestion_adherents.xlsm
      - choose save as and then the directory
      0
    3. diabete47
       
      Ok thanks, I managed in the meantime ;-)
      0
    4. gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
       
      In the file, I included the salutation with a list of choices, but it is possible to add more by adding the list in the "lists" tab, following it with the correct title in line 1.
      0