Forum Discussion
Error when copying or moving a sheet, name already exist
Bennadeau , Thank you for responding. When I hit No, its like i have to rename all the items that excel is saying already exist. That is going create more work for me. Is there another way?
How did you get there and what are you trying to achieve exactly? Sounds like you're duplicating all the sheets in a workbook within that same workbook?
Bennadeau, I am moving the sheet from one workbook to the next, but the workbook i am moving the sheet to has a similar sheet.
I see... can you delete the sheet in the destination workbook before moving these?
You could use VBA to do that operation if you have to do this often. I'm sure there's a way to force the operation in the code without confirmation prompt. (equivalent to "Yes to All"). Let me know if it's a recurring thing, I'll try to dig up a code for you. If it's a one time thing, I suggest you stick with deleting before copying.