{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Macros to Copy Sheets"],"not_rendered":{"charts":0,"images":4,"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":"Macros to Copy Sheets","index":0,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,1,3,2],[5,1,5,2],[8,2,8,3]]}
[]
[]
[]
[null,"Sample Workbook to Copy Sheets in Excel"]
[]
[null,"The workbook shows how to use the XMATCH function in Excel to get the relative position of a specific item in the array."]
[null,"Author","Ablebits.com"]
[null,"Last update","2018-11-16"]
[null,"Tutorial URL","How to duplicate sheet in Excel with VBA"]
[]
[null,"The workbook contains the following macros:"]
[null,"CopySheetToNewWorkbook - copies the current worksheet to a new workbook."]
[null,"CopySelectedSheets - copies multiple sheets that you select to a new workbook."]
[null,"CopySheetToBeginningAnotherWorkbook - copies the active sheet to the beginning of another workbook."]
[null,"CopySheetToEndAnotherWorkbook - copies the active sheet to the end of another Excel file."]
[null,"CopySheetAndRename - duplicates the current sheet, renames it as specified by the user, and puts the copy after all other sheets in the current workbook."]
[null,"CopySheetAndRenamePredefined - makes a copy of the active sheet with a hardcoded name and places it at the end of the current workbook."]
[null,"CopySheetAndRenameByCell - duplicates the active sheet and renames it based on the selected cell value."]
[null,"CopySheetAndRenameByCell2 - copies the active sheet and renames it based on the hardcoded cell address."]
[null,"CopySheetToClosedWorkbook - allows you to copy sheet to a closed workbook."]
[null,"CopySheetFromClosedWorkbook - allows you to copy sheet from another Excel file without opening it."]
[null,"DuplicateSheetMultipleTimes - lets you duplicate a sheet in Excel multiple times."]
[]
[null,"How to use the macros:"]
[null,"1. Keep this workbook open."]
[null,"2. Open your own workbook and navigate to the sheet you want to copy."]
[null,"3. In your worksheet, press Alt + F8, select the macro of interest, and click Run."]
[]
[]
[null,null,null,null,null,null," "]