{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["July","August","September","Macro"],"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":"July","index":0,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Computer Software Pty Ltd"]
["Sales for 2023"]
[]
["Rank","Sales Manager","Location ","July Sales $,000"]
[1,"Robin Hall","Toronto",1295]
[2,"Kenneth Walter","Osaka",1000]
[3,"Edward Khan","Prague",800]
[4,"Susan Dixon","Ho Chi Minh City",500]
[5,"Delia Muhammad","Bangalore",500]
[6,"David Walker","Athens",150]
[7,"Nicholas Holloway","Capetown",80]
[8,"Thomas Gordon","Tel Aviv",70]
[9,"James Ricketts","Sydney",50]
[]
[]
[]
["Did you remember that a workbook containing a macro needs to be saved in an Excel Macro-Enabled workbook with the file extension .xlsm?"]
["To record the Macro did you select the Developer tab from the menu?"]
["Did you select Record Macro from the Developer Ribbon?"]

{"sheet":"August","index":1,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Computer Software Pty Ltd"]
["Sales for 2023"]
[]
["Rank","Sales Manager","Location ","August Sales $,000"]
[1,"Edward Khan","Prague",910]
[2,"Nicholas Holloway","Capetown",584]
[3,"Thomas Gordon","Tel Aviv",495]
[4,"James Ricketts","Sydney",240]
[5,"Robin Hall","Toronto",138]
[6,"Kenneth Walter","Osaka",117]
[7,"Delia Muhammad","Bangalore",77]
[8,"David Walker","Athens",64]
[9,"Susan Dixon","Ho Chi Minh City",43]
[]
[]
[]
[]
["Did you edit the Macro?"]

{"sheet":"September","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Computer Software Pty Ltd"]
["Sales for 2023"]
[]
["Rank","Sales Manager","Location ","September Sales $,000"]
[1,"Delia Muhammad","Bangalore",760]
[2,"Thomas Gordon","Tel Aviv",686]
[3,"Edward Khan","Prague",465]
[4,"David Walker","Athens",137]
[5,"James Ricketts","Sydney",79]
[6,"Susan Dixon","Ho Chi Minh City",54]
[7,"Robin Hall","Toronto",37]
[8,"Kenneth Walter","Osaka",29]
[9,"Nicholas Holloway","Capetown",28]

{"sheet":"Macro","index":3,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Sub Ranking()"]
[null,"'"]
[null,"' Ranking Macro"]
[null,"' Sort Sales Managers into descending order and insert a ranking number."]
[null,"'"]
[null,"' Keyboard Shortcut: Ctrl+r"]
[null,"'"]
[null,"    Application.Goto Reference:=\"R4C1\""]
[null,"    ActiveSheet.Sort.SortFields.Clear"]
[null,"    ActiveSheet.Sort.SortFields.Add2 Key:=Range(\"D5:D13\"), _"]
[null,"        SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal"]
[null,"    With ActiveSheet.Sort"]
[null,"        .SetRange Range(\"A4:D13\")"]
[null,"        .Header = xlYes"]
[null,"        .MatchCase = False"]
[null,"        .Orientation = xlTopToBottom"]
[null,"        .SortMethod = xlPinYin"]
[null,"        .Apply"]
[null,"    End With"]
[null,"    Application.Goto Reference:=\"R5C1\""]
[null,"    Selection.FormulaR1C1 = \"1\""]
[null,"    Selection.AutoFill Destination:=Range(\"A5:A13\"), Type:=xlFillSeries"]
[null,"    Range(\"A5:A13\").Select"]
[null,"End Sub"]