{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Overview","Offset_in_WhileLoop","Offset_in_ForNextLoop","Offset_in_DoWhileLoop","ActiveCell","Studnet_Info","Query","Offset Function"],"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":"Overview","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Overview of Use of Offset Function in VBA Loop"]
[]
[null,"Fruits","Unit Price (Per Kg)","Jan","Feb","Mar","Total Sales","Revenue"]
[null,"Apple",1.1599999999999999,250,300,400,{"$f":"D5+E5+F5","v":950},1102]
[null,"Orange",2.2999999999999998,280,270,350,{"$f":"D6+E6+F6","v":900},2070]
[null,"Water Melon",2,100,110,80,290,580]
[null,"Guava",2.54,200,170,230,600,1524]
[null,"Mango",1.81,300,310,240,850,1538.5]
[null,"Cherry",5.54,120,130,170,420,2326.8000000000002]
[null," Strawberry",3,180,170,250,600,1800]
[null,"Peach",1.83,150,200,140,490,896.7]

{"sheet":"Offset_in_WhileLoop","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null," Using Offset Function Inside While Loop"]
[]
[null,"Fruits","Unit Price (Per Kg)","Jan","Feb","Mar","Total Sales","Revenue"]
[null,"Apple",1.1599999999999999,250,300,400,{"$f":"D5+E5+F5","v":950},1102]
[null,"Orange",2.2999999999999998,280,270,350,{"$f":"D6+E6+F6","v":900},2070]
[null,"Water Melon",2,100,110,80,290,580]
[null,"Guava",2.54,200,170,230,600,1524]
[null,"Mango",1.81,300,310,240,850,1538.5]
[null,"Cherry",5.54,120,130,170,420,2326.8000000000002]
[null," Strawberry",3,180,170,250,600,1800]
[null,"Peach",1.83,150,200,140,490,896.7]

{"sheet":"Offset_in_ForNextLoop","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null," Using Offset Function Inside For Next Loop"]
[]
[null,"Fruits","Unit Price (Per Kg)","Jan","Feb","Mar","Total Sales","Remarks"]
[null,"Apple",1.1599999999999999,250,300,400,{"$f":"D5+E5+F5","v":950},"Not Empty"]
[null,null,null,null,null,null,null,"Empty"]
[null,"Water Melon",2,100,110,80,{"$f":"D7+E7+F7","v":290},"Not Empty"]
[null,"Guava",2.54,200,170,230,600,"Not Empty"]
[null,null,null,null,null,null,null,"Empty"]
[null,"Cherry",5.54,120,130,170,420,"Not Empty"]
[null," Strawberry",3,180,170,250,600,"Not Empty"]
[null,"Peach",1.83,150,200,140,490,"Not Empty"]

{"sheet":"Offset_in_DoWhileLoop","index":3,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null," Using Offset Function Inside Do While Loop"]
[]
[null,"Fruits","Unit Price (Per Kg)","Jan","Feb","Mar","Max Sales"]
[null,"Apple",1.1599999999999999,250,300,400,400]
[null,"Orange",2.2999999999999998,380,270,350,380]
[null,"Water Melon",2,100,110,80,110]
[null,"Guava",2.54,200,170,230,230]
[null,"Mango",1.81,300,310,240,310]
[null,"Cherry",5.54,180,130,170,180]
[null," Strawberry",3,180,170,250,250]
[null,"Peach",1.83,150,200,140,200]

{"sheet":"ActiveCell","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Offset Function in VBA Loop with ActiveCell Command"]
[]
[null,"Fruits","Unit Price (Per Kg)","Jan","Feb","Mar"]
[null,"Apple",1.1599999999999999,250,300,400]
[null,"Orange",2.2999999999999998,280,270,350]
[null,"Water Melon",2,100,110,80]
[null,"Guava",2.54,200,170,230]
[null,"Mango",1.81,300,310,240]
[null,"Cherry",5.54,120,130,170]
[null," Strawberry",3,180,170,250]
[null,"Peach",1.83,150,200,140]

{"sheet":"Studnet_Info","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null," Using Offset Function in Loop to Find Values Matching Specific Criteria"]
[]
[null,"Name ","Physics","Chemistry","Math"]
[null,"Adam",84,56,74]
[null,"Jhon",78,85,56]
[null,"Merry",60,89,71]
[null,"Alisa",69,77,56]
[null,"Mira",65,89,77]
[null,"Smith",55,74,66]
[null,"Arya",80,79,91]
[null,"Harry",61,85,87]

{"sheet":"Query","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Output of Query"]
[]
[null,"Name ","Physics","Chemistry","Math"]
[null,"Adam",84,56,74]
[null,"Jhon",78,85,56]
[null,"Alisa",69,77,56]
[null,"Mira",65,89,77]
[null,"Arya",80,79,91]
[null,"Harry",61,85,87]

{"sheet":"Offset Function","index":7,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"OFFSET function in Excel VBA"]
[]
[null,"Name ","Physics","Chemistry","Math"]
[null,"Adam",84,56,74]
[null,"Jhon",78,85,56]
[null,"Merry",60,89,71]
[null,"Alisa",69,77,56]
[null,"Mira",65,89,77]
[null,"Smith",55,74,66]
[null,"Arya",80,79,91]
[null,"Harry",61,85,87]