In which case I do not understand your requirement.

Quote Originally Posted by RookieHelp! View Post
When I run it, it does not delete it from the name tabs, which is good, but it does not delete it from the 100 or other tab if it changes. It just adds it to them both
IT, IT, IT. You know what it you are talking about. I don't. Stop saying it! Start describing your requirement more precisely. Try explaining it again. It would be MORE useful to attach a workbook, showing what you start with, and what your required outcome looks like.