Mon 16 Aug 2010, 13:45Delegate Emma said...
Emma has attended:
Excel Intermediate course
Name Conflict
When I try to copy one sheet into another workbook a box comes up saying the 'name conflict dialogue box, name already exists on the destination worksheet'. This is especially irritating as this pops up and you have to click yes 100+. I was just wondering if there is any way of the computer ignoring this error?
Regards
Emma
Tue 17 Aug 2010, 17:41Trainer Anthony said...
RE: Name Conflict
Hi Emma, thanks for your query. In the Formulas tab of your worksheet, choose the Name manager. Select the name that is cited by the error dialogue box and delete it out. You may have to do this for more than one named range. When you copy it across that should solve the problem.
Hope this helps,
Anthony
