{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Notes","Copy_Resize"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":5,"comments":1,"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":"Notes","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Overview"]
[]
[null,null,"If you're interested to become better in Excel, check out my ONLINE COURSES."]
[]
[]
[null,null,"Sharing & Learning"]
[null,null,"Feel free to share this with anyone who can benefit!"]
[null,null,"Visit my other free Excel Tutorials."]

{"sheet":"Copy_Resize","index":1,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Copy & Resize Variably Sized Ranges"]
["Source Data",null,null,null,null,null,null,null,null,"Destination with copy method"]
[]
["Company","Business Unit","Actual Revenue","Budget Revenue","Variance",null,null,null,null,"Company","Business Unit","Actual Revenue","Budget Revenue","Variance"]
["Entity A","BU_1",10200,10404,{"$f":"C5/D5-1","v":-1.9607843137254943E-2},null,null,null,null,"Entity A","BU_1",10200,10404,{"$f":"L5/M5-1","v":-1.9607843137254943E-2}]
["Entity B","BU_1",12240,12484.800000000001,{"$f":"C6/D6-1","v":-1.9607843137254943E-2},null,null,null,null,"Entity B","BU_1",12240,12484.800000000001,{"$f":"L6/M6-1","v":-1.9607843137254943E-2}]
["Entity C","BU_1",14688,14981.76,-1.9607843137254943E-2,null,null,null,null,"Entity C","BU_1",14688,14981.76,-1.9607843137254943E-2]
["Entity D","BU_1",{"$f":"D8*1.1","v":19775.923199999997},17978.111999999997,0.10000000000000009,null,null,null,null,"Entity D","BU_1",{"$f":"M8*1.1","v":19775.923199999997},17978.111999999997,0.10000000000000009]
["Entity E","BU_2",10300,10506,-1.9607843137254943E-2,null,null,null,null,"Entity E","BU_2",10300,10506,-1.9607843137254943E-2]
["Entity F","BU_2",12360,12607.2,-1.9607843137254943E-2,null,null,null,null,"Entity F","BU_2",12360,12607.2,-1.9607843137254943E-2]
[]
[]
[]
[]
[]
[]
[]
["Paste here without header",null,null,null,null,null,null,null,null,"Destination with paste special method"]
[]
["Entity A","BU_1",10200,10404,-1.9607843137254943E-2,null,null,null,null,"Company","Business Unit","Actual Revenue","Budget Revenue","Variance"]
["Entity B","BU_1",12240,12484.800000000001,-1.9607843137254943E-2,null,null,null,null,"Entity A","BU_1",10200,10404,-1.9607843137254943E-2]
["Entity C","BU_1",14688,14981.76,-1.9607843137254943E-2,null,null,null,null,"Entity B","BU_1",12240,12484.800000000001,-1.9607843137254943E-2]
["Entity D","BU_1",19775.923199999997,17978.111999999997,0.10000000000000009,null,null,null,null,"Entity C","BU_1",14688,14981.76,-1.9607843137254943E-2]
["Entity E","BU_2",10300,10506,-1.9607843137254943E-2,null,null,null,null,"Entity D","BU_1",19775.923199999997,17978.111999999997,0.10000000000000009]
["Entity F","BU_2",12360,12607.2,-1.9607843137254943E-2,null,null,null,null,"Entity E","BU_2",10300,10506,-1.9607843137254943E-2]
[null,null,null,null,null,null,null,null,null,"Entity F","BU_2",12360,12607.2,-1.9607843137254943E-2]