{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Feuil1","fruits_légumes"," vêt_chauss","Alimentation","Boissons","CdC"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Référence produit"," Rayon","Chef de rayon","Date prévisionnelle de fin"," Dernière prévision de date finale","Rayon validé","Rapport envoyé"]
[1,"fruits/légumes","A","2013-10-10","2013-10-12","en préparation","OUI"]
[2,"Alimentation","B","2013-10-11","2013-10-14","en cours","NON"]
[3," vêt/chauss","C","2013-10-12","2013-10-16","terminée","NON"]
[4,"Alimentation","B","2013-10-13","2013-10-18","en préparation","OUI"]
[5," vêt/chauss","C","2013-10-14","2013-10-20","en cours","NON"]
[6,"fruits/légumes","A","2013-10-15","2013-10-22","terminée","NON"]
[7,"fruits/légumes","A","2013-10-16","2013-10-24","en préparation","OUI"]
[8," vêt/chauss","C","2013-10-17","2013-10-26","en cours","NON"]
[9,"Alimentation","B","2013-10-18","2013-10-28","terminée","NON"]
[10,"fruits/légumes","A","2013-10-19","2013-10-30","en préparation","OUI"]
[11,"fruits/légumes","A","2013-10-20","2013-11-01","en cours","NON"]
[12," vêt/chauss",null,"2013-10-21","2013-11-03","terminée","NON"]
[13,"fruits/légumes",null,"2013-10-22","2013-11-05","en préparation","OUI"]
[14,"fruits/légumes",null,"2013-10-23","2013-11-07","en cours","NON"]
[15,"boissons","D","2013-10-24","2013-11-09","terminée","NON"]
[16,"fruits/légumes","A","2013-10-25","2013-11-11","en préparation","OUI"]
[17," vêt/chauss","C","2013-10-26","2013-11-13","en cours","NON"]
[18,"boissons","D","2013-10-27","2013-11-15","terminée","NON"]
[19,"fruits/légumes","A","2013-10-28","2013-11-17","en préparation","OUI"]
[20,"boissons","D","2013-10-29","2013-11-19","en cours","NON"]
[21,"boissons","D","2013-10-30","2013-11-21","terminée","NON"]
[22," vêt/chauss","C","2013-10-31","2013-11-23","en préparation","OUI"]
[23,"Alimentation","B","2013-11-01","2013-11-25","en cours","NON"]
[24,"Alimentation","B","2013-11-02","2013-11-27","terminée","NON"]
[25,"Alimentation","B","2013-11-03","2013-11-29","en préparation","OUI"]
[26,"Alimentation","B","2013-11-04","2013-12-01","en cours","NON"]
[27,"Alimentation","B","2013-11-05","2013-12-03","terminée","NON"]
[28," vêt/chauss","C","2013-11-06","2013-12-05","en préparation","OUI"]

{"sheet":"fruits_légumes","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Référence produit"," Rayon","Chef de rayon","Date prévisionnelle de fin"," Dernière prévision de date finale","Rayon validé","Rapport envoyé"]
[1,"fruits/légumes","A","2013-10-10","2013-10-12","en préparation","OUI"]
[6,"fruits/légumes","A","2013-10-15","2013-10-22","terminée","NON"]
[7,"fruits/légumes","A","2013-10-16","2013-10-24","en préparation","OUI"]
[10,"fruits/légumes","A","2013-10-19","2013-10-30","en préparation","OUI"]
[11,"fruits/légumes","A","2013-10-20","2013-11-01","en cours","NON"]
[13,"fruits/légumes",null,"2013-10-22","2013-11-05","en préparation","OUI"]
[14,"fruits/légumes",null,"2013-10-23","2013-11-07","en cours","NON"]
[16,"fruits/légumes","A","2013-10-25","2013-11-11","en préparation","OUI"]
[19,"fruits/légumes","A","2013-10-28","2013-11-17","en préparation","OUI"]

{"sheet":" vêt_chauss","index":2,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Référence produit"," Rayon","Chef de rayon","Date prévisionnelle de fin"," Dernière prévision de date finale","Rayon validé","Rapport envoyé"]
[3," vêt/chauss","C","2013-10-12","2013-10-16","terminée","NON"]
[5," vêt/chauss","C","2013-10-14","2013-10-20","en cours","NON"]
[8," vêt/chauss","C","2013-10-17","2013-10-26","en cours","NON"]
[12," vêt/chauss",null,"2013-10-21","2013-11-03","terminée","NON"]
[17," vêt/chauss","C","2013-10-26","2013-11-13","en cours","NON"]
[22," vêt/chauss","C","2013-10-31","2013-11-23","en préparation","OUI"]
[28," vêt/chauss","C","2013-11-06","2013-12-05","en préparation","OUI"]

{"sheet":"Alimentation","index":3,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Référence produit"," Rayon","Chef de rayon","Date prévisionnelle de fin"," Dernière prévision de date finale","Rayon validé","Rapport envoyé"]
[2,"Alimentation","B","2013-10-11","2013-10-14","en cours","NON"]
[4,"Alimentation","B","2013-10-13","2013-10-18","en préparation","OUI"]
[9,"Alimentation","B","2013-10-18","2013-10-28","terminée","NON"]
[23,"Alimentation","B","2013-11-01","2013-11-25","en cours","NON"]
[24,"Alimentation","B","2013-11-02","2013-11-27","terminée","NON"]
[25,"Alimentation","B","2013-11-03","2013-11-29","en préparation","OUI"]
[26,"Alimentation","B","2013-11-04","2013-12-01","en cours","NON"]
[27,"Alimentation","B","2013-11-05","2013-12-03","terminée","NON"]

{"sheet":"Boissons","index":4,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Référence produit"," Rayon","Chef de rayon","Date prévisionnelle de fin"," Dernière prévision de date finale","Rayon validé","Rapport envoyé"]
[15,"boissons","D","2013-10-24","2013-11-09","terminée","NON"]
[18,"boissons","D","2013-10-27","2013-11-15","terminée","NON"]
[20,"boissons","D","2013-10-29","2013-11-19","en cours","NON"]
[21,"boissons","D","2013-10-30","2013-11-21","terminée","NON"]

{"sheet":"CdC","index":5,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["(Référence produit, Rayon ->fruits/légumes, vêt/chauss..., Chef de rayon, Statut -> en préparation, en cours, terminée..., Date prévisionnelle de fin, Dernière prévision de date finale, Rayon validé, Rapport envoyé)."]
[]
[null,"Un tableau général Excel à filtrer sous plusieurs feuilles"]
[]
[null,"MAY - 19 août 2013 à 15:52 - Dernière réponse le 21 août 2013 à 16:31 f894009 "]
[null,"Ne plus suivre"]
[null,"Bonjour,"]
[null,"Je suis débutante et ne connais presque rien de VBA."]
[null,"Dans Excel, j'ai un tableau avec environs 1000 lignes (qui se modifient tous les mois) et 8 colonnes (Référence produit, Rayon ->fruits/légumes, vêt/chauss..., Chef de rayon, Statut -> en préparation, en cours, terminée..., Date prévisionnelle de fin, Dernière prévision de date finale, Rayon validé, Rapport envoyé)."]
[null,"Je voudrais avoir une macro qui permette de filtrer les produits par rayon(1 rayon par feuille du classeur), sachant que les rayons contiennent un \"/\" et lorsque je veux nommer ces feuilles par le nom des rayons, il ne m'accepte pas les \"/\". Je ne peux pas changer le nom des rayon, ce sont des données brutes sorties d'une base de données. (rapport à renouveler tous les mois avec les nouvelles données)"]
[]
[null,"D'avance merci à celui qui pourra m'aider."]