This is kind of the same issue I dealt with earlier with trying to add and remove a persons name to every page in a workbook. The codes for adding and removing are working great but as the workbook was already created I am finding that some names had already been added to some pages of the workbook and left off others. Again i come to you experts as my rudimentary coding skill is not up to the task.
The code needs to look at a cell on my update page for a name, check all the other pages of the workbook to see if that name has been added yet and Let me know if it has. I am not sure what would be better, a list of pages that do have the name or a list of pages that do not?
Any help would be greatly appreciated.
Password for the document is "quality"
Bookmarks