{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Dataset","CopyPaste","Paste","Range","CopyRange","PasteSpecial","Last Cell","Clear Range","Copy Range","UsedRange","Paste Selected","Sheet13","IfCondition","Sheet15","WithFormula","Dataset (2)","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Dataset","index":0,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Copy and Paste Data from One Worksheet to Another with VBA"]
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","12/07/1985","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]

{"sheet":"CopyPaste","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Copy and Paste Data from One Worksheet to Another with VBA"]
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","1985-07-12","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]

{"sheet":"Paste","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Copy and Paste Data from One Worksheet to Another with VBA"]
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","1985-07-12","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]

{"sheet":"Range","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Copy this Cell"]

{"sheet":"CopyRange","index":4,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Copy this Cell"]

{"sheet":"PasteSpecial","index":5,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Copy and Paste Data from One Worksheet to Another with VBA"]
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","1985-07-12","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]

{"sheet":"Last Cell","index":6,"n_rows":539,"n_cols":6,"rows_kept":539,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Copy and Paste Data from One Worksheet to Another with VBA"]
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"Daniel","Brian","1975-02-02","Literature","B+"]
[null,"Brock","Lesner","1974-07-15","Multimedia","A"]
[null,"Triple","HHH","1989-11-21","Computer","A+"]
[null,"Rated R","Edge","1990-08-17","Business Studies","A-"]
[null,"Randy","Orton","1983-12-31","Networking","B"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","1985-07-12","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","1985-07-12","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","1985-07-12","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","1985-07-12","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","1985-07-12","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","1985-07-12","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]

{"sheet":"Clear Range","index":7,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Copy and Paste Data from One Worksheet to Another with VBA"]
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","1985-07-12","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]

{"sheet":"Copy Range","index":8,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Copy and Paste Data from One Worksheet to Another with VBA"]
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","1985-07-12","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]

{"sheet":"UsedRange","index":9,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Copy and Paste Data from One Worksheet to Another with VBA"]
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","1985-07-12","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]

{"sheet":"Paste Selected","index":10,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","12/07/1985","Biology","A"]

{"sheet":"Sheet13","index":11,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Copy and Paste Data from One Worksheet to Another with VBA"]
[]
["First Name","Last Name","Date of Birth","Department","Grade"]
["John","Cena","23/04/1977","Physics","A+"]
["Roman","Reigns","25/5/1985","Chemistry","B"]
["Dean","Ambrose","12/07/1985","Biology","A"]
["Seth","Rollins","28/5/1986","Mathematics","C"]
["Finn","Balor","25/07/1981","Language","A-"]

{"sheet":"IfCondition","index":12,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"f"]

{"sheet":"Sheet15","index":13,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"Dean","Ambrose","12/07/1985","Biology","A"]

{"sheet":"WithFormula","index":14,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Copy and Paste Data from One Worksheet to Another with VBA"]
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","12/07/1985","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]
[null,"Finn","Balor","25/07/1981","Language","A-"]

{"sheet":"Dataset (2)","index":15,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Copy and Paste Data from One Worksheet to Another with VBA"]
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"John","Cena","23/04/1977","Physics","A+"]
[null,"Roman","Reigns","25/5/1985","Chemistry","B"]
[null,"Dean","Ambrose","12/07/1985","Biology","A"]
[null,"Seth","Rollins","28/5/1986","Mathematics","C"]
[null,"Finn","Balor","25/07/1981","Language","A-"]

{"sheet":"Sheet2","index":16,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"Dean","Ambrose","12/07/1985","Biology","A"]
[null,"First Name","Last Name","Date of Birth","Department","Grade"]
[null,"Dean","Ambrose","12/07/1985","Biology","A"]