{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Saisie","Liste"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Saisie","index":0,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,3,3,4]]}
[null,null,">>>>>>>>",null,"All"]
[null,null,null,null,null,null,null,null,null,"Dans ce tableau, le filtre qui se trouve en cellule E1 a été créé en passant par :"]
[null,null,null,null,null,null,null,null,null,"Onglet Données, puis Validation des données"]
["Date","Client","Ville","Articles",null,"Prix"]
["2023-05-09","Tim Hagine","Nantes",1,{"$f":"VLOOKUP(D5,Liste!$A$3:$B$14,2,0)","v":"Téléviseur"},600,null,null,null,"Le tri se fait correctement mais seules 8 lignes sont affichées."]
["2023-05-03","Elvire Horouge","Bordeaux",2,{"$f":"VLOOKUP(D6,Liste!$A$3:$B$14,2,0)","v":"Tablette"},320]
["2023-05-03","André Naline","Toulouse",4,{"$f":"VLOOKUP(D7,Liste!$A$3:$B$14,2,0)","v":"Tableau blanc"},80,null,null,null,"Est-ce possible que la liste s'affiche entièrement (soit 13 lignes) ?"]
["2023-05-03","Lydie O’Duvillage","Nice",7,{"$f":"VLOOKUP(D8,Liste!$A$3:$B$14,2,0)","v":"Enceinte"},360]
["2023-05-03","Yvan Pèrémère","Paris",5,{"$f":"VLOOKUP(D9,Liste!$A$3:$B$14,2,0)","v":"I Phone"},350]
["2023-05-03","Axel Aire","Lille",6,{"$f":"VLOOKUP(D10,Liste!$A$3:$B$14,2,0)","v":"Ampli"},800,null,null,null,"Si possible, ce filtre peut-il fontionner sur cette feuille protégée"]
["2023-12-31","Alain Di","Marseille",5,{"$f":"VLOOKUP(D11,Liste!$A$3:$B$14,2,0)","v":"I Phone"},540]
["2023-01-01","Tim Hagine","Nantes",1,{"$f":"VLOOKUP(D12,Liste!$A$3:$B$14,2,0)","v":"Téléviseur"},1200]
["2023-05-12","Axel Aire","Lille",3,{"$f":"VLOOKUP(D13,Liste!$A$3:$B$14,2,0)","v":"Smartphone"},699]
["2023-01-01","André Naline","Toulouse",1,{"$f":"VLOOKUP(D14,Liste!$A$3:$B$14,2,0)","v":"Téléviseur"},400,null,null,null,"J'ai également essayé en passant par :"]
["2023-05-10","Alain Di","Marseille",5,{"$f":"VLOOKUP(D15,Liste!$A$3:$B$14,2,0)","v":"I Phone"},640,null,null,null,"Onglet Développeur, puis Zone de liste déroulante, (contrôle de formulaire)"]
["2023-01-02","Elvire Horouge","Bordeaux",12,{"$f":"VLOOKUP(D16,Liste!$A$3:$B$14,2,0)","v":"Module"},640,null,null,null,"Mais dans ce cas, il ne prend pas en compte la cellule E1"]
["2023-05-13","Yvan Pèrémère","Paris",8,{"$f":"VLOOKUP(D17,Liste!$A$3:$B$14,2,0)","v":"Hub"},40]
["2023-05-03","Axel Aire","Lille",9,{"$f":"VLOOKUP(D18,Liste!$A$3:$B$14,2,0)","v":"Clé USB 3"},35]
["2023-12-31","Alain Di","Marseille",10,{"$f":"VLOOKUP(D19,Liste!$A$3:$B$14,2,0)","v":"Clé USB C"},66]
["2023-01-01","Tim Hagine","Nantes",11,{"$f":"VLOOKUP(D20,Liste!$A$3:$B$14,2,0)","v":"Mixeur"},800]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"J'ai pris exemple sur ce site :  https://trumpexcel.com/vba-autofilter/"]
[null,null,null,null,null,null,null,null,null,"(Vers le milieu de la page. Paragraphe : Exemple : Filtrer les données en fonction d'une valeur de cellule)"]

{"sheet":"Liste","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"All"]
[1,"Téléviseur"]
[2,"Tablette",null,null,null,null,null,null,"Private Sub Workbook_Open()"]
[3,"Smartphone"]
[4,"Tableau blanc",null,null,null,null,null,null,"Sheets(\"Liste\").Select"]
[5,"I Phone",null,null,null,null,null,null,"    "]
[6,"Ampli",null,null,null,null,null,null,"    'Pour afficher en plein écran"]
[7,"Enceinte",null,null,null,null,null,null,"    Application.DisplayFullScreen = True"]
[8,"Hub",null,null,null,null,null,null,"    "]
[9,"Clé USB 3"]
[10,"Clé USB C"]
[11,"Mixeur",null,null,null,null,null,null,"    "]
[12,"Module",null,null,null,null,null,null,"    'Pour ne pas afficher le cadriage"]
[null,null,null,null,null,null,null,null,"    ActiveWindow.DisplayGridlines = False"]
[]
[null,null,null,null,null,null,null,null,"    'Pour ne pas afficher les entêtes de lignes et de colonnes"]
[null,null,null,null,null,null,null,null,"    ActiveWindow.DisplayHeadings = False"]
[]
[null,null,null,null,null,null,null,null,"    'Pour ne pas afficher l'ascenseur vertical"]
[null,null,null,null,null,null,null,null,"    ActiveWindow.DisplayVerticalScrollBar = False"]
[null,null,null,null,null,null,null,null,"    "]
[null,null,null,null,null,null,null,null,"    'Pour ne pas afficher l'ascenseur horizontal"]
[null,null,null,null,null,null,null,null,"    ActiveWindow.DisplayHorizontalScrollBar = False"]
[null,null,null,null,null,null,null,null,"       "]
[null,null,null,null,null,null,null,null,"    'Pour ne pas afficher les onglets"]
[null,null,null,null,null,null,null,null,"    ActiveWindow.DisplayWorkbookTabs = false"]
[]
[null,null,null,null,null,null,null,null,"End Sub"]