{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Úvod","Teorie","Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":8,"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":"Úvod","index":0,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,2,1,9],[9,2,10,6],[12,3,13,6],[13,7,13,9],[24,1,24,11]]}
[]
[null,null,"Jak na Excel   - VBA"]
[]
[]
[null,null,null,"Obsah cvičení"]
[null,null,null,null,"Úkol"]
[]
[]
[]
[null,null,"Pavel Lasák"]
[]
[]
[null,null,null,"Lektor, expert na Microsoft Excel, držitel prestižního ocenění Microsoftu MVP v České republice"]
[null,null,null,null,null,null,null,5002722]
[]
[]
[]
[]
[null,null,null,"Další informace ke cvičení:"]
[null,null,null,null,"https://office.lasakovi.com/excel/vba-priklady-kodu/filtry-autofilter-excel-vba/"]
[]
[]
[]
[]
[null,"Copyright, Pavel Lasák 2021"]

{"sheet":"Teorie","index":1,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
["Úkol"]
["http://office.lasakovi.com/"]
[]
[null,"08_VBA_Filtr","Složka"]
[null,"08s - VBA - Filtry - export na lisy rozhození.xlsm","Sešit"]
[null,"Teorie","List"]
[]
[null,"Úkol"]
[null,"Úkol z tabulky na listě Data potřebuji rozkopírovat do samostatných pdf souboru získat řádky na základě barvy"]
[null,"Tj. klikem na tlačítko zpravuj se na uloží samostatné soubory dle barev"]
[null,"Soubory budou ulozeny jako xlsx"]
[null,"Např:"]
[null,"Modra.xlsx a bude obsahovat jen řádky s Barvou ve sloupci C = Modrá"]
[]
[null,"Červena.xlsx - jen data  které mají ve sloupci červenou"]
[]
[null,"Poznámka:"]
[null,"Může se měnit počet řádku a názvy barev, například nějaká barví přibydou, nebo dojde k přejmenování červené na RED a následně se teda bude ukládat jako Red.xlsx"]
[]
[null,"Poznámka?"]
[null,"Viz ukázka"]
[null,"08s - VBA - Filtry - Export na listy rozhození - drroj.xlsm"]

{"sheet":"Data","index":2,"n_rows":62,"n_cols":7,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Rozměr délka","Rozměr výška","Barva","Materiál","Cena","Dodavatel","Datum"]
[99,98,"Modrá","Kov",125,"ABC","2012-08-01T14:05:00"]
[100,98,"Modrá","Plast",135,"ABC","2012-08-01T07:24:00"]
[100,98,"Modrá","Sklo rudé",145,"JakNaExcel.cz","2012-08-01T10:50:00"]
[100,98,"Modrá","Sklo zelené",155,"JakNaExcel.cz *","2012-08-01T09:00:00"]
[200,100,"Modrá","Kov",135,"CDEF","2012-08-01T09:15:00"]
[200,100,"Modrá","Plast",145,"CDEF**","2012-08-01T21:10:00"]
[200,98,"Modrá","Sklo rudé",155,"AAA","2012-08-01T19:50:00"]
[200,98,"Modrá","Sklo zelené",165,"ABC","2012-08-02T07:10:00"]
[200,98,"Zelená","Kov",175,"ABC","2012-08-02T07:10:00"]
[200,200,"Zelená","Plast",185,"ABC","2012-08-02T06:50:00"]
[200,200,"Zelená","Sklo rudé",195,"AAA","2012-08-02T07:20:00"]
[200,98,"Zelená","Sklo zelené",205,"AAAA","2012-08-02T11:40:00"]
[200,500,"Červená","Kov",215,"ABC","2012-08-02T15:50:00"]
[200,500,"Červená","Plast",225,"ABC","2012-08-02T16:25:00"]
[200,98,"Červená","Sklo rudé",235,"ABC","2012-08-03T04:55:00"]
[200,98,"Červená","Sklo zelené",245,"ABC","2012-08-03T06:00:00"]
[200,98,"Žlutá","Kov",255,"ABC","2012-08-03T14:20:00"]
[200,98,"Žlutá","Plast",265,"ABC","2012-08-03T18:20:00"]
[200,98,"Žlutá","Sklo rudé",275,"ABC","2012-08-03T18:40:00"]
[200,98,"Žlutá","Sklo zelené",285,"ABC","2012-08-03T20:00:00"]
[200,98,"Červená","Kov",295,"ABC","2012-08-03T20:45:00"]
[200,98,"Červená","Plast",305,"ABC","2012-08-04T06:40:00"]
[200,98,"Červená","Sklo rudé",315,"ABC","2012-08-05T11:40:00"]
[200,98,"Červená","Sklo zelené",325,"ABC","2012-08-05T06:35:00"]
[200,251,"Modrá","Kov",135,"CDEF","2012-08-05T06:50:00"]
[200,251,"Modrá","Plast",145,"CDEF","2012-08-05T22:40:00"]
[200,251,"Modrá","Sklo rudé",155,"CDEF","2012-08-06T14:00:00"]
[200,251,"Modrá","Sklo zelené",165,"CDEF","2012-08-06T14:00:00"]
[200,251,"Zelená","Kov",175,"CDEF","2012-08-06T11:40:00"]
[200,251,"Zelená","Plast",185,"CDEF","2012-08-06T09:00:00"]
[200,251,"Zelená","Sklo rudé",195,"CDEF","2012-08-06T08:11:00"]
[200,251,"Zelená","Sklo zelené",205,"CDEF","2012-08-06T08:50:00"]
[200,251,"Červená","Kov",100,"CDEF","2012-11-18"]
[200,251,"Červená","Plast",200,"CDEF","2012-08-06T15:22:00"]
[200,251,"Červená","Sklo rudé",300,"CDEF","2012-08-06T16:20:00"]
[200,251,"Červená","Sklo zelené",400,"CDEF","2012-08-06T18:40:00"]
[200,251,"Žlutá","Kov",500,"CDEF","2012-08-06T18:55:00"]
[200,251,"Žlutá","Plast",600,"CDEF","2012-08-06T20:35:00"]
[200,251,"Žlutá","Sklo rudé",700,"CDEF","2012-08-07T10:20:00"]
[200,251,"Žlutá","Sklo zelené",800,"CDEF","2012-08-07T10:45:00"]
[200,251,"Červená","Kov",900,"CDEF","2012-08-07T15:55:00"]
[200,251,"Červená","Plast",1000,"CDEF","2012-08-07T14:20:00"]
[200,251,"Červená","Sklo rudé",1100,"CDEF","2012-08-07T19:20:00"]
[200,251,"Červená","Sklo zelené",1200,"CDEF","2012-08-08T04:50:00"]
[200,321,"Modrá","Kov",135,"CDEF","2012-08-08T13:01:00"]
[200,321,"Modrá","Plast",145,"CDEF","2012-08-08T13:01:00"]
[200,321,"Modrá","Sklo rudé",155,"CDEF","2012-08-08T08:11:00"]
[200,321,"Modrá","Sklo zelené",165,"CDEF","2012-08-08T09:21:00"]
[200,321,"Zelená","Kov",175,"CDEF","2012-08-08T11:05:00"]
[200,321,"Zelená","Plast",185,"CDEF","2012-08-08T11:05:00"]
[200,321,"Zelená","Sklo rudé",195,"CDEF","2012-11-17"]
[200,321,"Zelená","Sklo zelené",205,"CDEF","2012-08-08T11:40:00"]
[200,321,"Červená","Kov",15,"CDEF","2012-08-08T12:20:00"]
[200,321,"Červená","Plast",25,"CDEF",{"$f":"G54+20","v":"2012-08-28T12:20:00"}]
[200,321,"Červená","Sklo rudé",35,"CDEF",{"$f":"G55+20","v":"2012-09-17T12:20:00"}]
[200,321,"Červená","Sklo zelené",45,"CDEF","2012-10-07T12:20:00"]
[200,321,"Žlutá","Kov",55,"CDEF","2012-10-27T12:20:00"]
[200,321,"Žlutá","Plast",65,"CDEF","2012-11-16T12:20:00"]
[200,321,"Žlutá","Sklo rudé",75,"CDEF","2012-12-06T12:20:00"]
[200,321,"Žlutá","Sklo zelené",85,"CDEF","2012-12-26T12:20:00"]
[200,321,"Červená","Kov",95,"CDEF","2013-01-15T12:20:00"]