{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["résultats","Bilan","macro"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"résultats","index":0,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Points à vérifier","Résultats"]
[1,"2018-01-01"]
[2]
[3]
[4]
[5,"2018-04-01"]
[6,null,null,"J'aimerais que chaque résultats puissent s'afficher dans la cellule de la feuille 2 selon le mois."]
[7,null,null,"Si on est en janvier, le résultat de la feuille 1 du point à verifier 1 s'affichera dans la colonne Q4 de la feuille 2 sur la même ligne"]
[8,"2018-10-01"]
[9]
[10]
[11,"2018-11-01"]
[12]
[13]
[]
[null,null,"J'ai deux feuilles d'un même classeur dont une contient 1 colonnes tandis que la seconde contient 4 colonnes qui correspond aux 4 trimestres de l'année."]
[]
[null,null,"Dans un premier temps j'ai réussi à lier les cellules entres elle en passant par VBA, mais j'aimerais ajouter la \"variable\" du mois en cours c'est à dire que lorsque je modifierais la cellule de la feuille 1 j'aimerais que le résultat s'affiche dans la colonne de la feuille 2 qui correspond au mois en cours."]
[]
[null,null,"Ce serait donc d'associer une seule cellule de la feuille 1 à 4 cellules de la feuille 2 mais dans lesquelles le résultat s'affiche dans la cellule selon le mois en cours"]
[]
[]
[null,null,"Mes colonnes de la feuille 2 sont :"]
[null,null,"Q1 = avril, mai, juin"]
[null,null,"Q2 = juillet, août, septembre"]
[null,null,"Q3 : octobre, novembre, décembre"]
[null,null,"Q4 : janvier, février, mars"]

{"sheet":"Bilan","index":1,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Q1 : avril, mai, juin",null,"Q1","Q2","Q3","Q4"]
["Q2 : juillet, août, septembre",null,5,null,8,1]
["Q3 : octobre, novembre, décembre",null,null,null,11]
["Q4 : janvier, février, mars"]

{"sheet":"macro","index":2,"n_rows":55,"n_cols":2,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Sub mise_à_jour()"]
[null,"' willy"]
[null,"Dim lemoias As Date"]
[null,"Dim resultat As String"]
[null,"Dim k As Integer"]
[]
[null,"If ActiveCell.Offset(0, -1).Column = 2 Then"]
[]
[null,"    If ActiveCell.Offset(0, -1) = \"\" Or Not IsDate(ActiveCell.Offset(0, -1)) Then Exit Sub"]
[null,"   "]
[null,"    li = 2"]
[null,"    If Range(\"B2\") = \"\" Then Exit Sub"]
[null,"  "]
[null,"    On Error Resume Next"]
[]
[null,"        lemois = Month(ActiveCell.Offset(0, -1))"]
[null,"        resultat = ActiveCell.Offset(0, -2)"]
[null,"        k = 2"]
[]
[null,"        Select Case lemois"]
[null,"        Case Is <= 3"]
[null,"        Do While Sheets(\"Bilan\").Range(\"F\" & k) <> \"\""]
[null,"        k = k + 1"]
[null,"        Loop"]
[null,"        Sheets(\"Bilan\").Range(\"F\" & k) = resultat"]
[null,"        GoTo suite"]
[]
[null,"        Case Is <= 6"]
[null,"        Do While Sheets(\"Bilan\").Range(\"C\" & k) <> \"\""]
[null,"        k = k + 1"]
[null,"        Loop"]
[null,"        Sheets(\"Bilan\").Range(\"C\" & k) = resultat"]
[null,"        GoTo suite"]
[null,"    "]
[null,"        Case Is <= 9"]
[null,"        Do While Sheets(\"Bilan\").Range(\"D\" & k) <> \"\""]
[null,"        k = k + 1"]
[null,"        Loop"]
[null,"        Sheets(\"Bilan\").Range(\"D\" & k) = resultat"]
[null,"        GoTo suite"]
[]
[null,"        Case Is <= 12"]
[null,"        Do While Sheets(\"Bilan\").Range(\"E\" & k) <> \"\""]
[null,"        k = k + 1"]
[null,"        Loop"]
[null,"        Sheets(\"Bilan\").Range(\"E\" & k) = resultat"]
[null,"        End Select"]
[null,"suite:"]
[]
[null,"   "]
[null,"End If"]
[]
[null,"End Sub"]