Error Worksheet Exists - need code to continue to next name if it does

Hi,

First of all, please input the code in the

Please Login or Register  to view this content.

selection box.

And You can try

Please Login or Register  to view this content.

for this

Thanks!
Moinuddin Shaikh

If you like my Response:
1. Show appreciation to those who have helped you by clicking below their posts.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

Appreciate someone towards their career path is better than saying Thanks!
-Moin

thanks for the quick response, where to I put that?

I can figure out how to use code, but not good at writing it or adding to it. Still novice in that area.



C

Hi,

When I try this code, it adds an additional copy of the Audittemp worksheet and changes the name of the existing worksheet. Thanks for trying, but what I need is to have a listing of names on Master Provider List and have it automatically copy the AuditTemp and rename that sheet with one of the names on the Master Provider List. thanks for the help.

Hi,

That worked !!!! Thank you so much.