{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["EndxlUp","EndxlDown","CurrentRegion","UsedRange","SpecialCells","Find","TableObject","LastRowPaste"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"EndxlUp","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using End(xlUp) Method"]
[]
[null,"Employee ID","Department","ID","Joining Date"]
[null,"Jhon","Finance","F-08","2023-02-05"]
[null,"Mira","Marketing","M-07","2023-02-08"]
[null,"Andrew","Finance","F-010","2023-02-10"]
[null,"Robert","Accounting","A-011","2023-02-08"]
[null,"Alisa","Marketing","M-014","2023-02-15"]
[null,"Paul","Finance","F-02","2023-01-28"]
[null,"Harry","Accounting","A-05","2023-01-25"]
[null,"Merry","Accounting","A-07","2023-01-28"]
[null,"Martha","Marketing","M-03","2023-01-20"]
[null,"Roy","Finance","F-02","2023-02-01"]

{"sheet":"EndxlDown","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using End(xlDown) Method"]
[]
[null,"Employee ID","Department","ID","Joining Date"]
[null,"Jhon","Finance","F-08","2023-02-05"]
[null,"Mira","Marketing","M-07","2023-02-08"]
[null,"Andrew","Finance","F-010","2023-02-10"]
[null,"Robert","Accounting","A-011","2023-02-08"]
[null,"Alisa","Marketing","M-014","2023-02-15"]
[null,"Paul","Finance","F-02","2023-01-28"]
[null,"Harry","Accounting","A-05","2023-01-25"]
[null,"Merry","Accounting","A-07","2023-01-28"]
[null,"Martha","Marketing","M-03","2023-01-20"]
[]
[null,"Roy","Finance","F-02","2023-02-01"]

{"sheet":"CurrentRegion","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying CurrentRegion Property"]
[]
[null,"Employee ID","Department","ID","Joining Date"]
[null,"Jhon","Finance","F-08","2023-02-05"]
[null,"Mira","Marketing","M-07","2023-02-08"]
[null,"Andrew","Finance","F-010","2023-02-10"]
[null,"Robert","Accounting","A-011","2023-02-08"]
[null,"Alisa","Marketing","M-014","2023-02-15"]
[null,"Paul","Finance","F-02","2023-01-28"]
[null,"Harry","Accounting","A-05","2023-01-25"]
[null,"Merry","Accounting","A-07","2023-01-28"]
[null,"Martha","Marketing","M-03","2023-01-20"]
[null,"Roy","Finance","F-02","2023-02-01"]

{"sheet":"UsedRange","index":3,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using UsedRange Property"]
[]
[null,"Employee ID","Department","ID","Joining Date"]
[null,"Jhon","Finance","F-08","2023-02-05"]
[null,"Mira","Marketing","M-07","2023-02-08"]
[null,"Andrew","Finance","F-010","2023-02-10"]
[null,"Robert","Accounting","A-011","2023-02-08"]
[null,"Alisa","Marketing","M-014","2023-02-15"]
[null,"Paul","Finance","F-02","2023-01-28"]
[null,"Harry","Accounting","A-05","2023-01-25"]
[null,"Merry","Accounting","A-07","2023-01-28"]
[null,"Martha","Marketing","M-03","2023-01-20"]
[]
[null,"Roy","Finance","F-02","2023-02-01"]

{"sheet":"SpecialCells","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying SpecialCells Method"]
[]
[null,"Employee ID","Department","ID","Joining Date"]
[null,"Jhon","Finance","F-08","2023-02-05"]
[null,"Mira","Marketing","M-07","2023-02-08"]
[null,"Andrew","Finance","F-010","2023-02-10"]
[null,"Robert","Accounting","A-011","2023-02-08"]
[null,"Alisa","Marketing","M-014","2023-02-15"]
[null,"Paul","Finance","F-02","2023-01-28"]
[null,"Harry","Accounting","A-05","2023-01-25"]
[null,"Merry","Accounting","A-07","2023-01-28"]
[null,"Martha","Marketing","M-03","2023-01-20"]
[]
[" ","Roy","Finance","F-02","2023-02-01"]

{"sheet":"Find","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Find Method"]
[]
[null,"Employee ID","Department","ID","Joining Date"]
[null,"Jhon","Finance","F-08","2023-02-05"]
[null,"Mira","Marketing","M-07","2023-02-08"]
[null,"Andrew","Finance","F-010","2023-02-10"]
[null,"Robert","Accounting","A-011","2023-02-08"]
[null,"Alisa","Marketing","M-014","2023-02-15"]
[null,"Paul","Finance","F-02","2023-01-28"]
[null,"Harry","Accounting","A-05","2023-01-25"]
[null,"Merry","Accounting","A-07","2023-01-28"]
[null,"Martha","Marketing","M-03","2023-01-20"]
[]
[null,"Roy","Finance","F-02","2023-02-01"]

{"sheet":"TableObject","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Selecting Last Row of Table Objects"]
[]
[null,"Employee ID","Department","ID","Joining Date"]
[null,"Jhon","Finance","F-08","2023-02-05"]
[null,"Mira","Marketing","M-07","2023-02-08"]
[null,"Andrew","Finance","F-010","2023-02-10"]
[null,"Robert","Accounting","A-011","2023-02-08"]
[null,"Alisa","Marketing","M-014","2023-02-15"]
[null,"Paul","Finance","F-02","2023-01-28"]
[null,"Harry","Accounting","A-05","2023-01-25"]
[null,"Merry","Accounting","A-07","2023-01-28"]
[null,"Martha","Marketing","M-03","2023-01-20"]
[null,"Roy","Finance","F-02","2023-02-01"]

{"sheet":"LastRowPaste","index":7,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"VBA Code to Find Last Row and Paste Data"]
[]
[null,"Employee ID","Department","ID","Joining Date",null,"Employee ID","Department","ID","Joining Date"]
[null,"Jhon","Finance","F-08","2023-02-05",null,"Adam","Accounting","A-014","2023-02-20"]
[null,"Mira","Marketing","M-07","2023-02-08"]
[null,"Andrew","Finance","F-010","2023-02-10"]
[null,"Robert","Accounting","A-011","2023-02-08"]
[null,"Alisa","Marketing","M-014","2023-02-15"]
[null,"Paul","Finance","F-02","2023-01-28"]
[null,"Harry","Accounting","A-05","2023-01-25"]
[null,"Merry","Accounting","A-07","2023-01-28"]
[null,"Martha","Marketing","M-03","2023-01-20"]
[null,"Roy","Finance","F-02","2023-02-01"]