{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Feuil1","CDC","Model_Fin","Feuil1 (2)"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"Feuil1","index":0,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["date","code journal","compte","debit","credit","Libellé","Piéce"]
[]
["2022-01-10","CDC",706400,0,"3908,13","Facture CLEMENT",100001]
["2022-01-10","CDC",706500,0,"142,58","Facture CLEMENT",100002]
["2022-01-10","CDC",445720,0,"390,78","Facture CLEMENT",100003]
["2022-01-10","CDC",445722,0,"28,51","Facture CLEMENT",100004]
["2022-01-10","CDC","0CLEMENT",4470,0,"Facture CLEMENT",100005]
["2022-01-10","CDC",706500,0,"142,58","Facture SOPHIE",100002]
["2022-01-10","CDC",445722,0,"28,51","Facture SOPHIE",100004]
["2022-01-10","CDC","0SOPHIE","171,09",0,"Facture SOPHIE",100005]
["2022-01-10","CDC",706400,0,"3908,13","Facture FROID",100001]
["2022-01-10","CDC",445720,0,"390,78","Facture FROID",100003]
["2022-01-10","CDC","0FROID","4298,91",0,"Facture FROID",100005]

{"sheet":"CDC","index":1,"n_rows":27,"n_cols":1,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Aujourd'hui ca fait 2 semaine que je suis sur une macro qu'on me demande a chaque fois des modifications !"]
[]
["En faite j'ai un export de données a intégrer dans un logiciel comptable ."]
[]
["MAINTENANT je dois faire une macro que Selon le compte client détecté \"706400\" qui correspond a la TVA 10% et \"445720\" son HT 10% et"]
[]
["\" 706500\" la TVA 20 % et son HT 20% \"445722\"qui se présente comme ceci sur tous mes dossiers"]
[]
[]
[]
["Sur ces lignes les deux comptes sont présents avec une dernière ligne \"le nom du client\""]
[]
["et en gros ma macro doit détecté si un compte Tva est détecté (ou les deux ) il faut afficher le mot TVA 10% ou TVA 20% après le nom du client et si il y a les deux Cela doit dédoublé la ligne du compte client comme ci-dessous"]
[]
[]
[]
["par contre quand cela dédouble la ligne pour la Tva 10%"]
[]
[]
["Ex: on fait la somme des comptes correspondant (706400 + 445720) en gros (3908.13 + 390.78 = 4298.91) pour la tva 10 %et pour les 20% (706500 + 445722) qui est (142.58 + 28.51 = 171.09)"]
[]
["mais des fois il se pourrait que une seul compte apparait comme ci-dessous et cela doit affiché Tva 20% après le nom de facture mais sans dédoublé de ligne"]
[]
[]
[]
[]
["ou pour les 10%"]

{"sheet":"Model_Fin","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["date","code journal","compte","debit","credit","Libellé","Piéce"]
[]
["2022-01-10","CDC",706400,0,"3908,13","Facture CLEMENT",100001]
["2022-01-10","CDC",706500,0,"142,58","Facture CLEMENT",100002]
["2022-01-10","CDC",445720,0,"390,78","Facture CLEMENT",100003]
["2022-01-10","CDC",445722,0,"28,51","Facture CLEMENT",100004]
["2022-01-10","CDC","0CLEMENT","4298,91",0,"Facture CLEMENT Tva 10%",100005]
["2022-01-10","CDC","0CLEMENT","171,09",0,"Facture CLEMENT Tva 20%",100005]
["2022-01-10","CDC",706500,0,"142,58","Facture SOPHIE",100002]
["2022-01-10","CDC",445722,0,"28,51","Facture SOPHIE",100004]
["2022-01-10","CDC","0SOPHIE","171,09",0,"Facture SOPHIE Tva 20%",100005]
["2022-01-10","CDC",706400,0,"3908,13","Facture FROID",100001]
["2022-01-10","CDC",445720,0,"390,78","Facture FROID",100003]
["2022-01-10","CDC","0FROID","4298,91",0,"Facture FROID Tva 10%",100005]

{"sheet":"Feuil1 (2)","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["date","code journal","compte","debit","credit","Libellé","Piéce"]
[]
["2022-01-10","CDC",706400,0,"3908,13","Facture CLEMENT",100001]
["2022-01-10","CDC",706500,0,"142,58","Facture CLEMENT",100002]
["2022-01-10","CDC",445720,0,"390,78","Facture CLEMENT",100003]
["2022-01-10","CDC",445722,0,"28,51","Facture CLEMENT",100004]
["2022-01-10","CDC","0CLEMENT",4298.91,0,"Facture CLEMENT Tva 10%",100005]
["2022-01-10","CDC","0CLEMENT",171.09,0,"Facture CLEMENT Tva 20%",100005]
["2022-01-10","CDC",706500,0,"142,58","Facture SOPHIE",100002]
["2022-01-10","CDC",445722,0,"28,51","Facture SOPHIE",100004]
["2022-01-10","CDC","0SOPHIE",171.09,0,"Facture SOPHIE Tva 20%",100005]
["2022-01-10","CDC",706400,0,"3908,13","Facture FROID",100001]
["2022-01-10","CDC",445720,0,"390,78","Facture FROID",100003]
["2022-01-10","CDC","0FROID",4298.91,0,"Facture FROID Tva 10%",100005]