{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["main","New","New (DIY)","S Text","VBA Find","mSheet1","mSheet2"],"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":"main","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"VBA to Insert Page Break Based on Cell Value"]
[]
[null,"Product","Brand","Price"]
[null,"Laptop","Apple",2479.94]
[null,"Laptop","Lenovo",1732.99]
[null,"Smart Watch","Apple",399]
[null,"Smart Watch","Samsung",183.9]
[null,"Fitness Tracker","Fitbit",149.94999999999999]
[null,"Fitness Tracker","Fitbit",129.94999999999999]

{"sheet":"New","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Inserting Page Break on New Cell Value"]
[]
[null,"Product","Brand","Price"]
[null,"Laptop","Apple",2479.94]
[null,"Laptop","Lenovo",1732.99]
[null,"Smart Watch","Apple",399]
[null,"Smart Watch","Samsung",183.9]
[null,"Fitness Tracker","Fitbit",149.94999999999999]
[null,"Fitness Tracker","Fitbit",129.94999999999999]

{"sheet":"New (DIY)","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice"]
[]
[null,"Product","Brand","Price"]
[null,"Laptop","Apple",2479.94]
[null,"Laptop","Lenovo",1732.99]
[null,"Smart Watch","Apple",399]
[null,"Smart Watch","Samsung",183.9]
[null,"Fitness Tracker","Fitbit",149.94999999999999]
[null,"Fitness Tracker","Fitbit",129.94999999999999]

{"sheet":"S Text","index":3,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[12,1,12,2],[9,1,9,2],[6,1,6,2],[1,5,1,7],[6,5,6,6],[9,5,9,6],[12,5,12,6]]}
[]
[null,"Adding Page Break After Specific Text",null,null,null,"Practice"]
[]
[null,"Product","Brand","Price",null,"Product","Brand","Price"]
[null,"Laptop","Apple",2479.94,null,"Laptop","Apple",2479.94]
[null,"Laptop","Lenovo",1732.99,null,"Laptop","Lenovo",1732.99]
[null,"Total",null,{"$f":"SUM(D5:D6)","v":4212.93},null,"Total",null,{"$f":"SUM(H5:H6)","v":4212.93}]
[null,"Smart Watch","Apple",399,null,"Smart Watch","Apple",399]
[null,"Smart Watch","Samsung",183.9,null,"Smart Watch","Samsung",183.9]
[null,"Total",null,{"$f":"SUM(D8:D9)","v":582.9},null,"Total",null,{"$f":"SUM(H8:H9)","v":582.9}]
[null,"Fitness Tracker","Fitbit",149.94999999999999,null,"Fitness Tracker","Fitbit",149.94999999999999]
[null,"Fitness Tracker","Fitbit",129.94999999999999,null,"Fitness Tracker","Fitbit",129.94999999999999]
[null,"Total",null,{"$f":"SUM(D11:D12)","v":279.89999999999998},null,"Total",null,{"$f":"SUM(H11:H12)","v":279.89999999999998}]

{"sheet":"VBA Find","index":4,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using VBA Find",null,null,null,"Practice"]
[]
[null,"Product","Brand","Price",null,"Product","Brand","Price"]
[null,"Laptop","Apple",2479.94,null,"Laptop","Apple",2479.94]
[null,"Laptop","Lenovo",1732.99,null,"Laptop","Lenovo",1732.99]
[null,"Total",null,{"$f":"SUM(D5:D6)","v":4212.93},null,"Total",null,{"$f":"SUM(H5:H6)","v":4212.93}]
[null,"Smart Watch","Apple",399,null,"Smart Watch","Apple",399]
[null,"Smart Watch","Samsung",183.9,null,"Smart Watch","Samsung",183.9]
[null,"Total",null,{"$f":"SUM(D8:D9)","v":582.9},null,"Total",null,{"$f":"SUM(H8:H9)","v":582.9}]
[null,"Fitness Tracker","Fitbit",149.94999999999999,null,"Fitness Tracker","Fitbit",149.94999999999999]
[null,"Fitness Tracker","Fitbit",129.94999999999999,null,"Fitness Tracker","Fitbit",129.94999999999999]
[null,"Total",null,{"$f":"SUM(D11:D12)","v":279.89999999999998},null,"Total",null,{"$f":"SUM(H11:H12)","v":279.89999999999998}]

{"sheet":"mSheet1","index":5,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Adding Page Break to Multiple Sheets on Condition (Sheet 1)",null,null,null,"Practice"]
[]
[null,"Product","Brand","Price",null,"Product","Brand","Price"]
[null,"Laptop","Apple",2479.94,null,"Laptop","Apple",2479.94]
[null,"Laptop","Lenovo",1732.99,null,"Laptop","Lenovo",1732.99]
[null,"Total",null,{"$f":"SUM(D5:D6)","v":4212.93},null,"Total",null,{"$f":"SUM(H5:H6)","v":4212.93}]
[null,"Smart Watch","Apple",399,null,"Smart Watch","Apple",399]
[null,"Smart Watch","Samsung",183.9,null,"Smart Watch","Samsung",183.9]
[null,"Total",null,{"$f":"SUM(D8:D9)","v":582.9},null,"Total",null,{"$f":"SUM(H8:H9)","v":582.9}]
[null,"Fitness Tracker","Fitbit",149.94999999999999,null,"Fitness Tracker","Fitbit",149.94999999999999]
[null,"Fitness Tracker","Fitbit",129.94999999999999,null,"Fitness Tracker","Fitbit",129.94999999999999]
[null,"Total",null,{"$f":"SUM(D11:D12)","v":279.89999999999998},null,"Total",null,{"$f":"SUM(H11:H12)","v":279.89999999999998}]

{"sheet":"mSheet2","index":6,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Adding Page Break to Multiple Sheets on Condition (Sheet 2)",null,null,null,"Practice"]
[]
[null,"Product","Brand","Price",null,"Product","Brand","Price"]
[null,"Laptop","Apple",2479.94,null,"Laptop","Apple",2479.94]
[null,"Laptop","Lenovo",1732.99,null,"Laptop","Lenovo",1732.99]
[null,"Total",null,{"$f":"SUM(D5:D6)","v":4212.93},null,"Total",null,{"$f":"SUM(H5:H6)","v":4212.93}]
[null,"Smart Watch","Apple",399,null,"Smart Watch","Apple",399]
[null,"Smart Watch","Samsung",183.9,null,"Smart Watch","Samsung",183.9]
[null,"Total",null,{"$f":"SUM(D8:D9)","v":582.9},null,"Total",null,{"$f":"SUM(H8:H9)","v":582.9}]
[null,"Fitness Tracker","Fitbit",149.94999999999999,null,"Fitness Tracker","Fitbit",149.94999999999999]
[null,"Fitness Tracker","Fitbit",129.94999999999999,null,"Fitness Tracker","Fitbit",129.94999999999999]
[null,"Total",null,{"$f":"SUM(D11:D12)","v":279.89999999999998},null,"Total",null,{"$f":"SUM(H11:H12)","v":279.89999999999998}]