Error when copying or moving a sheet, name already exist

Question

What do i do when yes to all does not appear? I feel like i have clicked a million yes already and the message is still showing up.&nbsp;&nbsp;

bennadeau · Answer

Hi&nbsp;Kaydeann,Click "No" give your sheet a different name, go back to the conflicting sheet, delete or rename it, and then rename the sheet you were trying to copy.

kaydeann · Answer

Bennadeau&nbsp;, 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?

bennadeau · Answer

Kaydeann&nbsp;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?&nbsp;

kaydeann · Answer

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.

bennadeau · Answer

Kaydeann&nbsp;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.

Forum Discussion

Error when copying or moving a sheet, name already exist

Share

Resources