{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Sheet1","Offset Range.Offset","Copy by Offset","Assign Values to Several Column","Offset whole column","Offset X Columns","Move right column","Offset Range VBA","Offset Loop in Excel 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":"Sheet1","index":0,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Offset Whole Column to Right",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name ","Gender","Age","Occupation",null,null,null,null,null,null,"Name ","Gender","Age","Occupation"]
[null,"Alex","Male",34,"Artist",null,null,null,null,null,null,"Alex","Male",34,"Artist"]
[null,"Jon","Male",45,"Engineer",null,null,null,null,null,null,"Jon","Male",45,"Engineer"]
[null,"Brandon","Male",28,"Doctor",null,null,null,null,null,null,"Brandon","Male",28,"Doctor"]
[null,"Camelia","Female",31,"Singer",null,null,null,null,null,null,"Camelia","Female",31,"Singer"]
[null,"Dwaine","Male",43,"Teacher",null,null,null,null,null,null,"Dwaine","Male",43,"Teacher"]
[null,"Ketty","Female",51,"Businessman",null,null,null,null,null,null,"Ketty","Female",51,"Businessman"]
[null,"Sara","Female",30,"student",null,null,null,null,null,null,"Sara","Female",30,"student"]
[null,"Chris ","Male",26,"Engineer",null,null,null,null,null,null,"Chris ","Male",26,"Engineer"]

{"sheet":"Offset Range.Offset","index":1,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Offset by Range.Offset",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name ","Gender","Age","Occupation",null,null,null,null,null,null,"Name ","Gender","Age","Occupation"]
[null,"Alex","Male",34,"Artist",null,null,null,null,null,null,"Alex","Male",34,"Artist"]
[null,"Jon","Male",45,"Engineer",null,null,null,null,null,null,"Jon","Male",45,"Engineer"]
[null,"Brandon","Male",28,"Doctor",null,null,null,null,null,null,"Brandon","Male",28,"Doctor"]
[null,"Camelia","Female",31,"Singer",null,null,null,null,null,null,"Camelia","Female",31,"Singer"]
[null,"Dwaine","Male",43,"Teacher",null,null,null,null,null,null,"Dwaine","Male",43,"Teacher"]
[null,"Ketty","Female",51,"Businessman",null,null,null,null,null,null,"Ketty","Female",51,"Businessman"]
[null,"Sara","Female",30,"student",null,null,null,null,null,null,"Sara","Female",30,"student"]
[null,"Chris ","Male",26,"Engineer",null,null,null,null,null,null,"Chris ","Male",26,"Engineer"]

{"sheet":"Copy by Offset","index":2,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Copy Column by Offset",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name ","Gender","Age","Occupation",null,null,null,null,null,null,null,"Name ","Gender","Age","Occupation"]
[null,"Alex","Male",34,"Artist",null,null,null,null,null,null,null,"Alex","Male",34,"Artist"]
[null,"Jon","Male",45,"Engineer",null,null,null,null,null,null,null,"Jon","Male",45,"Engineer"]
[null,"Brandon","Male",28,"Doctor",null,null,null,null,null,null,null,"Brandon","Male",28,"Doctor"]
[null,"Camelia","Female",31,"Singer",null,null,null,null,null,null,null,"Camelia","Female",31,"Singer"]
[null,"Dwaine","Male",43,"Teacher",null,null,null,null,null,null,null,"Dwaine","Male",43,"Teacher"]
[null,"Ketty","Female",51,"Businessman",null,null,null,null,null,null,null,"Ketty","Female",51,"Businessman"]
[null,"Sara","Female",30,"student",null,null,null,null,null,null,null,"Sara","Female",30,"student"]
[null,"Chris ","Male",26,"Engineer",null,null,null,null,null,null,null,"Chris ","Male",26,"Engineer"]

{"sheet":"Assign Values to Several Column","index":3,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Assign Values by Offset",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,1,2,3,4,5,null,null,null,null,null,1,2,3,4,5]
[null,"Apple","Banana","Orange","Pear","Grape",null,null,null,null,null,"Apple","Banana","Orange","Pear","Grape"]

{"sheet":"Offset whole column","index":4,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Offset Whole Column Selection",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name ","Gender","Age","Occupation",null,null,null,null,null,null,"Name ","Gender","Age","Occupation"]
[null,"Alex","Male",34,"Artist",null,null,null,null,null,null,"Alex","Male",34,"Artist"]
[null,"Jon","Male",45,"Engineer",null,null,null,null,null,null,"Jon","Male",45,"Engineer"]
[null,"Brandon","Male",28,"Doctor",null,null,null,null,null,null,"Brandon","Male",28,"Doctor"]
[null,"Camelia","Female",31,"Singer",null,null,null,null,null,null,"Camelia","Female",31,"Singer"]
[null,"Dwaine","Male",43,"Teacher",null,null,null,null,null,null,"Dwaine","Male",43,"Teacher"]
[null,"Ketty","Female",51,"Businessman",null,null,null,null,null,null,"Ketty","Female",51,"Businessman"]
[null,"Sara","Female",30,"student",null,null,null,null,null,null,"Sara","Female",30,"student"]
[null,"Chris ","Male",26,"Engineer",null,null,null,null,null,null,"Chris ","Male",26,"Engineer"]

{"sheet":"Offset X Columns","index":5,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Offset X Number of Cells",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name ","Gender","Age","Occupation",null,null,null,null,null,null,null,"Name ","Gender","Age","Occupation"]
[null,"Alex","Male",34,"Artist",null,null,null,null,null,null,null,"Alex","Male",34,"Artist"]
[null,"Jon","Male",45,"Engineer",null,null,null,null,null,null,null,"Jon","Male",45,"Engineer"]
[null,"Brandon","Male",28,"Doctor",null,null,null,null,null,null,null,"Brandon","Male",28,"Doctor"]
[null,"Camelia","Female",31,"Singer",null,null,null,null,null,null,null,"Camelia","Female",31,"Singer"]
[null,"Dwaine","Male",43,"Teacher",null,null,null,null,null,null,null,"Dwaine","Male",43,"Teacher"]
[null,"Ketty","Female",51,"Businessman",null,null,null,null,null,null,null,"Ketty","Female",51,"Businessman"]
[null,"Sara","Female",30,"student",null,null,null,null,null,null,null,"Sara","Female",30,"student"]
[null,"Chris ","Male",26,"Engineer",null,null,null,null,null,null,null,"Chris ","Male",26,"Engineer"]

{"sheet":"Move right column","index":6,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Move to Right Column",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name ","Gender","Age","Occupation",null,null,null,null,null,"Name ","Gender","Age","Occupation"]
[null,"Alex","Male",34,"Artist",null,null,null,null,null,"Alex","Male",34,"Artist"]
[null,"Jon","Male",45,"Engineer",null,null,null,null,null,"Jon","Male",45,"Engineer"]
[null,"Brandon","Male",28,"Doctor",null,null,null,null,null,"Brandon","Male",28,"Doctor"]
[null,"Camelia","Female",31,"Singer",null,null,null,null,null,"Camelia","Female",31,"Singer"]
[null,"Dwaine","Male",43,"Teacher",null,null,null,null,null,"Dwaine","Male",43,"Teacher"]
[null,"Ketty","Female",51,"Businessman",null,null,null,null,null,"Ketty","Female",51,"Businessman"]
[null,"Sara","Female",30,"student",null,null,null,null,null,"Sara","Female",30,"student"]
[null,"Chris ","Male",26,"Engineer",null,null,null,null,null,"Chris ","Male",26,"Engineer"]

{"sheet":"Offset Range VBA","index":7,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Offset Range in VBA",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name ","Gender","Age","Occupation",null,null,null,null,null,null,"Name ","Gender","Age","Occupation"]
[null,"Alex","Male",34,"Artist",null,null,null,null,null,null,"Alex","Male",34,"Artist"]
[null,"Jon","Male",45,"Engineer",null,null,null,null,null,null,"Jon","Male",45,"Engineer"]
[null,"Brandon","Male",28,"Doctor",null,null,null,null,null,null,"Brandon","Male",28,"Doctor"]
[null,"Camelia","Female",31,"Singer",null,null,null,null,null,null,"Camelia","Female",31,"Singer"]
[null,"Dwaine","Male",43,"Teacher",null,null,null,null,null,null,"Dwaine","Male",43,"Teacher"]
[null,"Ketty","Female",51,"Businessman",null,null,null,null,null,null,"Ketty","Female",51,"Businessman"]
[null,"Sara","Female",30,"student",null,null,null,null,null,null,"Sara","Female",30,"student"]
[null,"Chris ","Male",26,"Engineer",null,null,null,null,null,null,"Chris ","Male",26,"Engineer"]

{"sheet":"Offset Loop in Excel VBA","index":8,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Offset Loop in VBA",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Number in Physics","Number in English","Total Marks",null,null,null,null,null,"Name","Number in Physics","Number in English","Total Marks"]
[null,"John",44,76,120,null,null,null,null,null,"John",44,76,120]
[null,"Milly",78,53,131,null,null,null,null,null,"Milly",78,53,131]
[null,"Ron",62,54,116,null,null,null,null,null,"Ron",62,54,116]
[null,"Chris",86,40,126,null,null,null,null,null,"Chris",86,40,126]
[null,"Sarah",75,53,128,null,null,null,null,null,"Sarah",75,53,128]
[null,"Miller",49,71,120,null,null,null,null,null,"Miller",49,71,120]