{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Array","Range","Dynamic_Named_Range","UserForm"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":5},"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":"Dataset","index":0,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,13,1,15]]}
[]
[null,"Sales Data of Companies",null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Company","Item","Sales",null,"Sum of Sales","Column Labels",null,null,null,null,null,null,"Company","Item","Sales"]
[null,"Company 1","Apple",963,null,"Row Labels","Company 1","Company 2","Company 3","Grand Total",null,null,null,"Company 1","Apple",963]
[null,"Company 1","Banana",829,null,"Apple",963,685,649,2297,null,null,null,"Company 1","Banana",829]
[null,"Company 1","Tomato",952,null,"Banana",829,733,296,1858,null,null,null,"Company 1","Tomato",952]
[null,"Company 1","Mango",176,null,"Mango",176,765,721,1662,null,null,null,"Company 1","Mango",176]
[null,"Company 1","Guava",511,null,"Tomato",952,398,563,1913,null,null,null,"Company 1","Guava",511]
[null,"Company 2","Apple",685,null,"Guava",511,509,733,1753,null,null,null,"Company 2","Apple",685]
[null,"Company 2","Banana",733,null,"Grand Total",3431,3090,2962,9483,null,null,null,"Company 2","Banana",733]
[null,"Company 2","Tomato",398,null,null,null,null,null,null,null,null,null,"Company 2","Tomato",398]
[null,"Company 2","Mango",765,null,null,null,null,null,null,null,null,null,"Company 2","Mango",765]
[null,"Company 2","Guava",509,null,null,null,null,null,null,null,null,null,"Company 2","Guava",509]
[null,"Company 3","Apple",649,null,null,null,null,null,null,null,null,null,"Company 3","Apple",649]
[null,"Company 3","Banana",296,null,null,null,null,null,null,null,null,null,"Company 3","Banana",296]
[null,"Company 3","Tomato",563,null,null,null,null,null,null,null,null,null,"Company 3","Tomato",563]
[null,"Company 3","Mango",721,null,null,null,null,null,null,null,null,null,"Company 3","Mango",721]
[null,"Company 3","Guava",733,null,null,null,null,null,null,null,null,null,"Company 3","Guava",733]

{"sheet":"Array","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Applying VBA to Filter Pivot Table Based on Array "]
[]
[null,"Sum of Sales","Column Labels"]
[null,"Row Labels","Company 1","Company 2","Company 3","Grand Total"]
[null,"Apple",963,685,649,2297]
[null,"Banana",829,733,296,1858]
[null,"Mango",176,765,721,1662]
[null,"Tomato",952,398,563,1913]
[null,"Guava",511,509,733,1753]
[null,"Grand Total",3431,3090,2962,9483]

{"sheet":"Range","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Applying VBA to Filter Pivot Table Based on Range"]
[]
[null,"Sum of Sales","Column Labels",null,null,null,null,"List"]
[null,"Row Labels","Company 1","Company 2","Company 3","Grand Total",null,"Apple"]
[null,"Apple",963,685,649,2297,null,"Banana"]
[null,"Banana",829,733,296,1858,null,"Mango"]
[null,"Mango",176,765,721,1662]
[null,"Tomato",952,398,563,1913]
[null,"Guava",511,509,733,1753]
[null,"Grand Total",3431,3090,2962,9483]

{"sheet":"Dynamic_Named_Range","index":3,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Applying VBA to Filter Pivot Table Based on Dynamic Named Range"]
[]
[null,"Sum of Sales","Column Labels",null,null,null,null,"List"]
[null,"Row Labels","Company 1","Company 2","Company 3","Grand Total",null,"Apple"]
[null,"Apple",963,685,649,2297,null,"Banana"]
[null,"Banana",829,733,296,1858,null,"Mango"]
[null,"Mango",176,765,721,1662]
[null,"Tomato",952,398,563,1913]
[null,"Guava",511,509,733,1753]
[null,"Grand Total",3431,3090,2962,9483]

{"sheet":"UserForm","index":4,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Creating UserForm to Filter Pivot Table Based on List"]
[]
[null,"Sum of Sales","Column Labels",null,null,null,null,"List"]
[null,"Row Labels","Company 1","Company 2","Company 3","Grand Total",null,"Apple"]
[null,"Apple",963,685,649,2297,null,"Banana"]
[null,"Banana",829,733,296,1858,null,"Mango"]
[null,"Mango",176,765,721,1662]
[null,"Tomato",952,398,563,1913]
[null,"Guava",511,509,733,1753]
[null,"Grand Total",3431,3090,2962,9483]