{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Copy the Cell Ranges","INDIRECT Function","March"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":24,"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":"Copy the Cell Ranges","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Copy the Cell Ranges to Merge Data",null,null,null,"Try Yourself"]
[]
[null,"Salesperson","Region","Sales",null,"Salesperson","Region","Sales"]
[null,"Sam","Canada",887656,null,"Sam","Canada",887656]
[null,"Peter","USA",997845,null,"Peter","USA",997845]
[null,"Jack","Brazil",836745,null,"Jack","Brazil",836745]
[null,"Oliver","Brazil",778923]
[null,"Samuel","UK",999320]
[null,"Willium","London",584738]
[null,"Aron","Canada",734895]
[null,"Brook","UK",788665]
[null,"Ron","London",903472]

{"sheet":"INDIRECT Function","index":1,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Use of Excel INDIRECT Function"]
[]
[null,"Salesperson","Workbook","Sheet","Row","Column","Sales"]
[null,"Oliver","[Workbook_1.xlsx]","March",3,"D",{"$f":"INDIRECT(\"'\"&$C5&$D5&\"'!\"&$F$5&$E$5)","v":778923}]
[null,"Aron","[Workbook_2.xlsx]","February",3,"D",{"$f":"INDIRECT(\"'\"&$C6&$D6&\"'!\"&$F$5&$E$5)","v":734895}]

{"sheet":"March","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Data Using VBA"]
[]
[null,"Salesperson","Region","Sales"]
[null,"Oliver","Brazil",778923]
[null,"Samuel","UK",999320]
[null,"Willium","London",584738]