{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","IF Statement & For Next Loop ","Apply On Error Statement","LBound and UBound Functions","Displaying Counts on MsgBox","Practice Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"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":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,2],[3,3,3,4]]}
[]
[null,"Breaking Links"]
[]
[null,"January",null,"February"]
[null,{"$f":"'[1]Sales January'!$B$4:$C$10","v":"Salesperson"},"Sales",{"$f":"'[2]Sales February'!$B$4:$C$10","v":"Salesperson"},"Sales"]
[null,"Jim",1500,"Jim",1650]
[null,"Rachel",1680,"Rachel",1350]
[null,"Mike",1260,"Mike",1400]
[null,"Danny",1850,"Danny",1990]
[null,"Penny",1340,"Penny",1050]
[null,"Monica",1900,"Monica",2100]

{"sheet":"IF Statement & For Next Loop ","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,2],[3,3,3,4]]}
[]
[null,"Using IF Statement with For Next Loop"]
[]
[null,"January",null,"February"]
[null,{"$f":"'[1]Sales January'!$B$4:$C$10","v":"Salesperson"},"Sales",{"$f":"'[2]Sales February'!$B$4:$C$10","v":"Salesperson"},"Sales"]
[null,"Jim",1500,"Jim",1650]
[null,"Rachel",1680,"Rachel",1350]
[null,"Mike",1260,"Mike",1400]
[null,"Danny",1850,"Danny",1990]
[null,"Penny",1340,"Penny",1050]
[null,"Monica",1900,"Monica",2100]

{"sheet":"Apply On Error Statement","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,2],[3,3,3,4]]}
[]
[null,"Applying On Error Statement"]
[]
[null,"January",null,"February"]
[null,{"$f":"'[1]Sales January'!$B$4:$C$10","v":"Salesperson"},"Sales",{"$f":"'[2]Sales February'!$B$4:$C$10","v":"Salesperson"},"Sales"]
[null,"Jim",1500,"Jim",1650]
[null,"Rachel",1680,"Rachel",1350]
[null,"Mike",1260,"Mike",1400]
[null,"Danny",1850,"Danny",1990]
[null,"Penny",1340,"Penny",1050]
[null,"Monica",1900,"Monica",2100]

{"sheet":"LBound and UBound Functions","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,2],[3,3,3,4]]}
[]
[null,"Employing LBound and UBound Functions"]
[]
[null,"January",null,"February"]
[null,{"$f":"'[1]Sales January'!$B$4:$C$10","v":"Salesperson"},"Sales",{"$f":"'[2]Sales February'!$B$4:$C$10","v":"Salesperson"},"Sales"]
[null,"Jim",1500,"Jim",1650]
[null,"Rachel",1680,"Rachel",1350]
[null,"Mike",1260,"Mike",1400]
[null,"Danny",1850,"Danny",1990]
[null,"Penny",1340,"Penny",1050]
[null,"Monica",1900,"Monica",2100]

{"sheet":"Displaying Counts on MsgBox","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,2],[3,3,3,4]]}
[]
[null,"Displaying Count on MsgBox"]
[]
[null,"January",null,"February"]
[null,{"$f":"'[1]Sales January'!$B$4:$C$10","v":"Salesperson"},"Sales",{"$f":"'[2]Sales February'!$B$4:$C$10","v":"Salesperson"},"Sales"]
[null,"Jim",1500,"Jim",1650]
[null,"Rachel",1680,"Rachel",1350]
[null,"Mike",1260,"Mike",1400]
[null,"Danny",1850,"Danny",1990]
[null,"Penny",1340,"Penny",1050]
[null,"Monica",1900,"Monica",2100]

{"sheet":"Practice Sheet","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,3,2],[3,3,3,4]]}
[]
[null,"Do It Yourself"]
[]
[null,"January",null,"February"]
[null,{"$f":"'[1]Sales January'!$B$4:$C$10","v":"Salesperson"},"Sales",{"$f":"'[2]Sales February'!$B$4:$C$10","v":"Salesperson"},"Sales"]
[null,"Jim",1500,"Jim",1650]
[null,"Rachel",1680,"Rachel",1350]
[null,"Mike",1260,"Mike",1400]
[null,"Danny",1850,"Danny",1990]
[null,"Penny",1340,"Penny",1050]
[null,"Monica",1900,"Monica",2100]