{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Dataset","Method 1","Method 1 (2)","Method 2","Method 2 (2)","Method 3","Method 3 (2)","Method 4","Method 4 (2)","Method 5","Method 5 (2)","Method 6","Dataset2","Method 7","Method 8","Exercise"],"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":"Dataset","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dataset"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Adam Smith"},"adamsmith@gmail.com"]
[null,"Scott ","Murdock",{"$f":"_xlfn.CONCAT(B6,C6)","v":"Scott Murdock"},"scotmdock@gmail.com"]
[null,"Rachel ","Ross","Rachel Ross","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]

{"sheet":"Method 1","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Copying Range to Last Row of Another Workbook"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Adam Smith"},"adamsmith@gmail.com"]
[null,"Scott","Murdock",{"$f":"_xlfn.CONCAT(B6,C6)","v":"ScottMurdock"},"scotmdock@gmail.com"]
[null,"Rachel","Ross","RachelRoss","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]

{"sheet":"Method 1 (2)","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA to Copy Without Formatting"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Adam Smith"},"adamsmith@gmail.com"]
[null,"Scott","Murdock",{"$f":"_xlfn.CONCAT(B6,C6)","v":"ScottMurdock"},"scotmdock@gmail.com"]
[null,"Rachel","Ross","RachelRoss","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]

{"sheet":"Method 2","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA to Copy Without Formatting"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Adam Smith"},"adamsmith@gmail.com"]
[null,"Scott","Murdock",{"$f":"_xlfn.CONCAT(B6,C6)","v":"ScottMurdock"},"scotmdock@gmail.com"]
[null,"Rachel","Ross","RachelRoss","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]

{"sheet":"Method 2 (2)","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using VBA to Copy Without Formatting"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith","Adam Smith","adamsmith@gmail.com"]
[null,"Scott","Murdock","ScottMurdock","scotmdock@gmail.com"]
[null,"Rachel","Ross","RachelRoss","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]

{"sheet":"Method 3","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Copying Range with Formatting and Column Width"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Adam Smith"},"adamsmith@gmail.com"]
[null,"Scott","Murdock",{"$f":"_xlfn.CONCAT(B6,C6)","v":"ScottMurdock"},"scotmdock@gmail.com"]
[null,"Rachel","Ross","RachelRoss","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]

{"sheet":"Method 3 (2)","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Copying Range with Formatting and Column Width"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Adam Smith"},"adamsmith@gmail.com"]
[null,"Scott","Murdock",{"$f":"_xlfn.CONCAT(B6,C6)","v":"ScottMurdock"},"scotmdock@gmail.com"]
[null,"Rachel","Ross","RachelRoss","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]

{"sheet":"Method 4","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilizing VBA to Copy Range with Formula"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Adam Smith"},"adamsmith@gmail.com"]
[null,"Scott","Murdock",{"$f":"_xlfn.CONCAT(B6,C6)","v":"ScottMurdock"},"scotmdock@gmail.com"]
[null,"Rachel","Ross","RachelRoss","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]

{"sheet":"Method 4 (2)","index":8,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilizing VBA to Copy Range with Formula"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Adam Smith"},"adamsmith@gmail.com"]
[null,"Scott","Murdock",{"$f":"_xlfn.CONCAT(B6,C6)","v":"ScottMurdock"},"scotmdock@gmail.com"]
[null,"Rachel","Ross","RachelRoss","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]

{"sheet":"Method 5","index":9,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Copying Range with AutoFit"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Adam Smith"},"adamsmith@gmail.com"]
[null,"Scott","Murdock",{"$f":"_xlfn.CONCAT(B6,C6)","v":"ScottMurdock"},"scotmdock@gmail.com"]
[null,"Rachel","Ross","RachelRoss","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]

{"sheet":"Method 5 (2)","index":10,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Copying Range with AutoFit"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Adam Smith"},"adamsmith@gmail.com"]
[null,"Scott","Murdock",{"$f":"_xlfn.CONCAT(B6,C6)","v":"ScottMurdock"},"scotmdock@gmail.com"]
[null,"Rachel","Ross","RachelRoss","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]

{"sheet":"Method 6","index":11,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying VBA to Copy Range to Another Workbook"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Adam Smith"},"adamsmith@gmail.com"]
[null,"Scott","Murdock",{"$f":"_xlfn.CONCAT(B6,C6)","v":"ScottMurdock"},"scotmdock@gmail.com"]
[null,"Rachel","Ross","RachelRoss","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]

{"sheet":"Dataset2","index":12,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"Full Name","Email","Address"]
[null,"Adam Smith","adamsmith@gmail.com","2101 Waverley Street"]
[null,"Scott Murdock","scotmdock@gmail.com","1835  NE, Medina"]
[null,"Rachel Ross","rachelross@gmail.com","105,TS, New York"]
[null,"Victor Rosario","victorosari@gmail.com","321 Waverley Street"]
[null,"Kristin Moran","kristinmoran@gmail.com","675 East Buena Vista "]
[null,"Julia Johnson","juliajohn@gmail.com","3500 Deer , Palo Alto"]
[null,"Elaine Gardner","elainegard@gmail.com","104 Miami,Florida"]

{"sheet":"Method 7","index":13,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Copying Range to Last Row of Another Sheet"]
[]
[null,"Full Name","Email","Address"]
[null,"Adam Smith","adamsmith@gmail.com","2101 Waverley Street"]
[null,"Scott Murdock","scotmdock@gmail.com","1835  NE, Medina"]
[null,"Rachel Ross","rachelross@gmail.com","105,TS, New York"]
[null,"Victor Rosario","victorosari@gmail.com","321 Waverley Street"]
[null,"Kristin Moran","kristinmoran@gmail.com","675 East Buena Vista "]
[null,"Julia Johnson","juliajohn@gmail.com","3500 Deer , Palo Alto"]
[null,"Elaine Gardner","elainegard@gmail.com","104 Miami,Florida"]
[null,"Adam Smith","adamsmith@gmail.com","2101 Waverley Street"]
[null,"Scott Murdock","scotmdock@gmail.com","1835  NE, Medina"]
[null,"Rachel Ross","rachelross@gmail.com","105,TS, New York"]
[null,"Victor Rosario","victorosari@gmail.com","321 Waverley Street"]
[null,"Kristin Moran","kristinmoran@gmail.com","675 East Buena Vista "]
[null,"Julia Johnson","juliajohn@gmail.com","3500 Deer , Palo Alto"]
[null,"Elaine Gardner","elainegard@gmail.com","104 Miami,Florida"]

{"sheet":"Method 8","index":14,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Copying Range to Last Row of Another Workbook"]
[]
[null,"Full Name","Email","Address"]
[null,"Adam Smith","adamsmith@gmail.com","2101 Waverley Street"]
[null,"Scott Murdock","scotmdock@gmail.com","1835  NE, Medina"]
[null,"Rachel Ross","rachelross@gmail.com","105,TS, New York"]
[null,"Victor Rosario","victorosari@gmail.com","321 Waverley Street"]
[null,"Kristin Moran","kristinmoran@gmail.com","675 East Buena Vista "]
[null,"Julia Johnson","juliajohn@gmail.com","3500 Deer , Palo Alto"]
[null,"Elaine Gardner","elainegard@gmail.com","104 Miami,Florida"]

{"sheet":"Exercise","index":15,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Try Yourself"]
[]
[null,"First Name","Last Name","Full Name","Email"]
[null,"Adam ","Smith",{"$f":"_xlfn.CONCAT(B5,C5)","v":"Adam Smith"},"adamsmith@gmail.com"]
[null,"Scott ","Murdock",{"$f":"_xlfn.CONCAT(B6,C6)","v":"Scott Murdock"},"scotmdock@gmail.com"]
[null,"Rachel ","Ross","Rachel Ross","rachelross@gmail.com"]
[null,"Victor ","Rosario","Victor Rosario","victorosari@gmail.com"]
[null,"Kristin ","Moran","Kristin Moran","kristinmoran@gmail.com"]
[null,"Julia ","Johnson","Julia Johnson","juliajohn@gmail.com"]
[null,"Elaine ","Gardner","Elaine Gardner","elainegard@gmail.com"]