{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Dataset","If Statement & For Loop","Filter Feature with VBA","Delete Row if Cell is Empty","Delete Blank Rows","Specific Criteria Set by User","Based on Cells in Other Sheet","Delete Row On Another Sheet","Remove Duplicate Rows","Delete Entire Row by Cell Value","Delete Row and Shift Up","Cell Value is Not One Desired","Delete Rows Multiple Criteria","Empty & Non-Empty Cells","Practice Sheet"],"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":"Dataset","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Net Sales of Products"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14101,"Wilham","Cable",2600]
[null,14102,"Ruby","AC",11500]
[null,null,"Frank","TV",13500]
[null,14104,"Nathan","Fridge",17000]
[null,14105,"Jaxson","Router"]
[null,14106,"Anthony","Cable",10000]
[null,14107,"John","TV",16000]

{"sheet":"If Statement & For Loop","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combination of If Statement and For Loop"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14102,"Ruby","AC",11500]
[null,null,"Frank","TV",13500]
[null,14104,"Nathan","Fridge",17000]
[null,14105,"Jaxson","Router"]
[null,14107,"John","TV",16000]

{"sheet":"Filter Feature with VBA","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Filter Feature in VBA"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14102,"Ruby","AC",11500]
[null,null,"Frank","TV",13500]
[null,14104,"Nathan","Fridge",17000]
[null,14105,"Jaxson","Router"]
[null,14107,"John","TV",16000]

{"sheet":"Delete Row if Cell is Empty","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Rows If Cell Is Empty"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14101,"Wilham","Cable",2600]
[null,14102,"Ruby","AC",11500]
[null,14104,"Nathan","Fridge",17000]
[null,14106,"Anthony","Cable",10000]
[null,14107,"John","TV",16000]

{"sheet":"Delete Blank Rows","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Blank Rows"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14101,"Wilham","Cable",2600]
[null,14102,"Ruby","AC",11500]
[null,null,"Frank","TV",13500]
[null,14104,"Nathan","Fridge",17000]
[null,14105,"Jaxson","Router"]
[null,14106,"Anthony","Cable",10000]
[null,14107,"John","TV",16000]

{"sheet":"Specific Criteria Set by User","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Rows Based on Specific Criteria Set by User"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14101,"Wilham","Cable",2600]
[null,14102,"Ruby","AC",11500]
[null,14104,"Nathan","Fridge",17000]
[null,14105,"Jaxson","Router"]
[null,14106,"Anthony","Cable",10000]

{"sheet":"Based on Cells in Other Sheet","index":6,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Rows Based on Cells in Another Sheet"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,1,"Wilham","Cable",2600]
[null,3,"Frank","TV",13500]
[null,5,"Jaxson","Router"]
[null,6,"Anthony","Cable",10000]

{"sheet":"Delete Row On Another Sheet","index":7,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Row on Another Sheet"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14101,"Wilham","Cable",2600]
[null,14102,"Ruby","AC",11500]
[null,14107,"John","TV",16000]

{"sheet":"Remove Duplicate Rows","index":8,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Removing Duplicate Rows"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14101,"Wilham","Cable",2600]
[null,14102,"Ruby","AC",11500]
[null,14104,"Nathan","Fridge",17000]
[null,14106,"Anthony","Cable",10000]

{"sheet":"Delete Entire Row by Cell Value","index":9,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Entire Row Based on Cell Value"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14102,"Ruby","AC",11500]
[null,null,"Frank","TV",13500]
[null,14104,"Nathan","Fridge",17000]
[null,14105,"Jaxson","Router"]
[null,14107,"John","TV",16000]

{"sheet":"Delete Row and Shift Up","index":10,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Row with VBA and Shift Up"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14101,"Wilham","Cable",2600]
[null,14102,"Ruby","AC",11500]
[null,14104,"Nathan","Fridge",17000]
[null,14105,"Jaxson","Router"]
[null,14106,"Anthony","Cable",10000]
[null,14107,"John","TV",16000]

{"sheet":"Cell Value is Not One Desired","index":11,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Rows If Cell Value Is Not One of Desired Values"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14101,"Wilham","Cable",2600]
[null,null,"Frank","TV",13500]
[null,14104,"Nathan","Fridge",17000]
[null,14106,"Anthony","Cable",10000]
[null,14107,"John","TV",16000]

{"sheet":"Delete Rows Multiple Criteria","index":12,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Rows Based on Multiple Criteria"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14101,"Wilham","Cable",2600]
[null,14102,"Ruby","AC",11500]
[null,null,"Frank","TV",13500]
[null,14104,"Nathan","Fridge",17000]
[null,14105,"Jaxson","Router"]
[null,14106,"Anthony","Cable",10000]

{"sheet":"Empty & Non-Empty Cells","index":13,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Deleting Rows Based on Empty & Non-Empty Cells"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14101,"Wilham","Cable",2600]
[null,14102,"Ruby","AC",11500]
[null,14104,"Nathan","Fridge",17000]
[null,14105,"Jaxson","Router"]
[null,14106,"Anthony","Cable",10000]
[null,14107,"John","TV",16000]

{"sheet":"Practice Sheet","index":14,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Practice Yourself"]
[]
[null,"ID","Salesman","Product","Net Sales"]
[null,14101,"Wilham","Cable",2600]
[null,14102,"Ruby","AC",11500]
[null,null,"Frank","TV",13500]
[null,14104,"Nathan","Fridge",17000]
[null,14105,"Jaxson","Router"]
[null,14106,"Anthony","Cable",10000]
[null,14107,"John","TV",16000]