{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","For...Next","Quantity Criteria","Date Criteria","Do...Loop","Value in First Column","Highlight_VBA","Extract","Delete Other Rows","Highlight Without VBA"],"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":"Dataset","index":0,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Delivery Status Report"]
[]
[null,"Name","Date","Product","Qty","Status"]
[null,"David","2023-02-28","Mango",20,"Delivered"]
[null,"Maxx","2023-02-28","Banana",24,"Not Delivered"]
[null,"Henry","2023-03-02","Orange",22,"Not Delivered"]
[null,"Rahul","2023-03-05","Tangerin",10,"Delivered"]
[null,"Nick","2023-03-05","Tamarind",21,"Delivered"]
[null,"Charollete","2023-03-06","Apricot",12,"Not Delivered"]
[null,"William","2023-03-09","Kiwi",6,"Not Delivered"]
[null,"Dev","2023-03-09","Avocado",12,"Delivered"]
[null,"Harry","2023-03-10","Jackfruit",2,"Not Delivered"]
[null,"Sheron","2023-03-10","Durian",10,"Delivered"]

{"sheet":"For...Next","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Selecting Row Using For…Next Statement"]
[]
[null,"Name","Date","Product","Qty","Status"]
[null,"David","2023-02-28","Mango",20,"Delivered"]
[null,"Maxx","2023-02-28","Banana",24,"Not Delivered"]
[null,"Henry","2023-03-02","Orange",22,"Not Delivered"]
[null,"Rahul","2023-03-05","Tangerin",10,"Delivered"]
[null,"Nick","2023-03-05","Tamarind",21,"Delivered"]
[null,"Charollete","2023-03-06","Apricot",12,"Not Delivered"]
[null,"William","2023-03-09","Kiwi",6,"Not Delivered"]
[null,"Dev","2023-03-09","Avocado",12,"Delivered"]
[null,"Harry","2023-03-10","Jackfruit",2,"Not Delivered"]
[null,"Sheron","2023-03-10","Durian",10,"Delivered"]

{"sheet":"Quantity Criteria","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Selecting Rows by Quantity Criteria"]
[]
[null,"Name","Date","Product","Qty","Status"]
[null,"David","2023-02-28","Mango",20,"Delivered"]
[null,"Maxx","2023-02-28","Banana",24,"Not Delivered"]
[null,"Henry","2023-03-02","Orange",22,"Not Delivered"]
[null,"Rahul","2023-03-05","Tangerin",10,"Delivered"]
[null,"Nick","2023-03-05","Tamarind",21,"Delivered"]
[null,"Charollete","2023-03-06","Apricot",12,"Not Delivered"]
[null,"William","2023-03-09","Kiwi",6,"Not Delivered"]
[null,"Dev","2023-03-09","Avocado",12,"Delivered"]
[null,"Harry","2023-03-10","Jackfruit",2,"Not Delivered"]
[null,"Sheron","2023-03-10","Durian",10,"Delivered"]

{"sheet":"Date Criteria","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Selecting Rows by Date Criteria"]
[]
[null,"Name","Date","Product","Qty","Status"]
[null,"David","2023-02-28","Mango",20,"Delivered"]
[null,"Maxx","2023-02-28","Banana",24,"Not Delivered"]
[null,"Henry","2023-03-02","Orange",22,"Not Delivered"]
[null,"Rahul","2023-03-05","Tangerin",10,"Delivered"]
[null,"Nick","2023-03-05","Tamarind",21,"Delivered"]
[null,"Charollete","2023-03-06","Apricot",12,"Not Delivered"]
[null,"William","2023-03-09","Kiwi",6,"Not Delivered"]
[null,"Dev","2023-03-09","Avocado",12,"Delivered"]
[null,"Harry","2023-03-10","Jackfruit",2,"Not Delivered"]
[null,"Sheron","2023-03-10","Durian",10,"Delivered"]

{"sheet":"Do...Loop","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Do…Loop Statement to Select Rows"]
[]
[null,"Name","Date","Product","Qty","Status"]
[null,"David","2023-02-28","Mango",20,"Delivered"]
[null,"Maxx","2023-02-28","Banana",24,"Not Delivered"]
[null,"Henry","2023-03-02","Orange",22,"Not Delivered"]
[null,"Rahul","2023-03-05","Tangerin",10,"Delivered"]
[null,"Nick","2023-03-05","Tamarind",21,"Delivered"]
[null,"Charollete","2023-03-06","Apricot",12,"Not Delivered"]
[null,"William","2023-03-09","Kiwi",6,"Not Delivered"]
[null,"Dev","2023-03-09","Avocado",12,"Delivered"]
[null,"Harry","2023-03-10","Jackfruit",2,"Not Delivered"]
[null,"Sheron","2023-03-10","Durian",10,"Delivered"]

{"sheet":"Value in First Column","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Selecting Rows That Have Data in First Column"]
[]
[null,"Name","Date","Product","Qty","Status"]
[null,"David","2023-02-28","Mango",20,"Delivered"]
[null,"Maxx","2023-02-28","Banana",24,"Not Delivered"]
[null,null,"2023-03-02","Orange",22,"Not Delivered"]
[null,"Rahul","2023-03-05","Tangerin",10,"Delivered"]
[null,null,"2023-03-05","Tamarind",21,"Delivered"]
[null,"Charollete","2023-03-06","Apricot",12,"Not Delivered"]
[null,null,"2023-03-09","Kiwi",6,"Not Delivered"]
[null,null,"2023-03-09","Avocado",12,"Delivered"]
[null,"Harry","2023-03-10","Jackfruit",2,"Not Delivered"]
[null,"Sheron","2023-03-10","Durian",10,"Delivered"]

{"sheet":"Highlight_VBA","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Highlighting Row Based on Cell Value with VBA"]
[]
[null,"Name","Date","Product","Qty","Status"]
[null,"David","2023-02-28","Mango",20,"Delivered"]
[null,"Maxx","2023-02-28","Banana",24,"Not Delivered"]
[null,"Henry","2023-03-02","Orange",22,"Not Delivered"]
[null,"Rahul","2023-03-05","Tangerin",10,"Delivered"]
[null,"Nick","2023-03-05","Tamarind",21,"Delivered"]
[null,"Charollete","2023-03-06","Apricot",12,"Not Delivered"]
[null,"William","2023-03-09","Kiwi",6,"Not Delivered"]
[null,"Dev","2023-03-09","Avocado",12,"Delivered"]
[null,"Harry","2023-03-10","Jackfruit",2,"Not Delivered"]
[null,"Sheron","2023-03-10","Durian",10,"Delivered"]

{"sheet":"Extract","index":7,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,5],[15,1,15,5]]}
[]
[null,"Extracting Rows Based on Cell Value with VBA"]
[]
[null,"Name","Date","Product","Qty","Status"]
[null,"David","2023-02-28","Mango",20,"Delivered"]
[null,"Maxx","2023-02-28","Banana",24,"Not Delivered"]
[null,"Henry","2023-03-02","Orange",22,"Not Delivered"]
[null,"Rahul","2023-03-05","Tangerin",10,"Delivered"]
[null,"Nick","2023-03-05","Tamarind",21,"Delivered"]
[null,"Charollete","2023-03-06","Apricot",12,"Not Delivered"]
[null,"William","2023-03-09","Kiwi",6,"Not Delivered"]
[null,"Dev","2023-03-09","Avocado",12,"Delivered"]
[null,"Harry","2023-03-10","Jackfruit",2,"Not Delivered"]
[null,"Sheron","2023-03-10","Durian",10,"Delivered"]
[]
[null,"Extracted Data"]
[null,"David","2023-02-28","Mango",20,"Delivered"]
[null,"Rahul","2023-03-05","Tangerin",10,"Delivered"]
[null,"Nick","2023-03-05","Tamarind",21,"Delivered"]
[null,"Dev","2023-03-09","Avocado",12,"Delivered"]
[null,"Sheron","2023-03-10","Durian",10,"Delivered"]

{"sheet":"Delete Other Rows","index":8,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Deleting All Other Rows Based on Cell Value"]
[]
[null,"Name","Date","Product","Qty","Status"]
[null,"David","2023-02-28","Mango",20,"Delivered"]
[null,"Rahul","2023-03-05","Tangerin",10,"Delivered"]
[null,"Nick","2023-03-05","Tamarind",21,"Delivered"]
[null,"Dev","2023-03-09","Avocado",12,"Delivered"]
[null,"Sheron","2023-03-10","Durian",10,"Delivered"]

{"sheet":"Highlight Without VBA","index":9,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Highlighting Rows with Different Color Based on Multiple Criteria Without VBA"]
[]
[null,"Name","Date","Product","Qty","Status"]
[null,"David","2023-02-28","Mango",20,"Delivered"]
[null,"Maxx","2023-02-28","Banana",24,"Not Delivered"]
[null,"Henry","2023-03-02","Orange",22,"Not Delivered"]
[null,"Rahul","2023-03-05","Tangerin",10,"Delivered"]
[null,"Nick","2023-03-05","Tamarind",21,"Delivered"]
[null,"Charollete","2023-03-06","Apricot",12,"Not Delivered"]
[null,"William","2023-03-09","Kiwi",6,"Not Delivered"]
[null,"Dev","2023-03-09","Avocado",12,"Delivered"]
[null,"Harry","2023-03-10","Jackfruit",2,"Not Delivered"]
[null,"Sheron","2023-03-10","Durian",10,"Delivered"]