View original (French)

Voting Record Matrix in General Assembly of Co-ownership

ASB7869 Posted messages 12 Registration date   Status Member Last intervention   -  
ASB7869 Posted messages 12 Registration date   Status Member Last intervention   -
Hello everyone,

I experimented last year with a matrix that works with a few exceptions...
Could you help me finalize it?

1/ I would like, depending on the choice made in column D ("Result"), that columns F; J; N; R; V; Z; AD modify automatically:
- Choice "Present" ==> by default "Yes" instead of "-"
- Choice "Absent" ==> by default "-"

2/ The COUNTIF formula does not work (rows 22; 23; 24) except in column D

I am attaching the corresponding file:
https://www.cjoint.com/c/ICdq3p26WIW

Thank you in advance for your help,

Configuration: Windows / Firefox 65.0

3 answers

  1.
    via55 Posted messages 14396 Registration date   Status Member Last intervention   2 759
     
    Hello

    Your file with a macro to put yes or - depending on the choice of the dropdown in D
    https://mon-partage.fr/f/A3pZk78n/

    However, I had to change the validations of the voting columns as the INDIRECT function was no longer working

    As for the COUNTIF formula, it works well in all columns

    Best regards
    Via

    0
    1. ASB7869 Posted messages 12 Registration date   Status Member Last intervention  
       
      Thank you for your incredibly quick response. I’m impressed... but completely useless!
      When I try it on one line, it works, but not on the next one...
      Furthermore, how should I link my xls file to your macro file so that it works on my different voting tabs?
      Best regards,
      ASB7869
      0
  2. via55 Posted messages 14396 Registration date   Status Member Last intervention   2 759
     
    I don't understand, it works for all lines in column D
    The macro is associated with the sheet
    Press ALT+F11 to open the VBA editor and see the macro
    This macro applies to the range D11:D21 of the sheet and is triggered by any change in this range

    If you want it to apply to other sheets, you copy the macro and then in the tree structure on the left with the sheets of the editor, you double-click on the sheet where you want to apply the macro and then paste the macro into the blank sheet

    If you want to change the range, for example on another sheet the range is D11:D30, you just need to change the references in the macro line If Not Intersect(Target, Range("D11:D21")) Is Nothing Then

    Then in the macro we loop through columns 6 to 24 in steps of 4 columns
    For col = 6 To 26 Step 4

    You can also adjust the numbers in the loop if you have more or fewer columns

    If you can't do it, provide me with the complete file via cjoint and I'll take a look

    --
    "Imagination is more important than knowledge." A. Einstein
    0
  3. ASB7869 Posted messages 12 Registration date   Status Member Last intervention  
     
    Dear Via55,
    Absolutely useless, I gladly accept your proposal to directly modify my file ...
    Thank you in advance for your valuable help,
    And have a good Sunday!
    ASB7869

    Here is the link to my file
    https://www.cjoint.com/c/ICkogLW2N1W
    0