{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Title","Sheet1","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":1,"defined_names":20,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2082]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: sign/post/f53b4795-9306-4e3d-a46e / Pixabay"]

{"sheet":"Sheet1","index":1,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Account","Data",null,null,"Pam from Indy:"]
[100,{"$f":"+ROW()^3","v":8}]
[108,27,null,null,"For each cell in A:"]
[112,64,null,null,"Create a new worksheet"]
[364,125,null,null,"Put the corresponding cell from B in cell B1"]
[1059,216]
[5014841,343]

{"sheet":"Wrap Up","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Pam wants to to create a worksheet for each account number"]
[null,"Currently, she is using the Show Report Filter Pages"]
[null,"Looking for a faster way"]
[null,"Save the workbook as XLSM"]
[null,"Check Macro Security with Alt+T M S & set to second level"]
[null,"Alt+F11"]
[null,"Insert Module"]
[null,"Type the code as shown"]
[null,"Alt+Q to return to Excel"]
[null,"Alt+F8"]
[null,"Select the macro & click Options"]
[null,"Assign to Ctrl+Shift+W"]