Forum Discussion
Duplicate several sheets inside one workbook
Hello
I built a financial simulator in a workbook using 5 sheets interrelated with formulas, etc. The sheets are embedded.
I need to duplicate those 5 sheets at once in the same workbook (like to have 2 simulators in the same workbook) but I can't because it says "you cannot copy or move a group of sheets that contain a table". Do you have a solution ?
Thank you in advance
This is a limitation of Excel.
If a worksheet contains at least one table, you'll have to copy (duplicate) it by itself. As the error message indicates, it is impossible to copy such a sheet if it is grouped with other sheets.
