remove someone completely from workbook

[chriswrcg]

I need two macros (or one if we combine them) that remove someone completely from a workbook.
I have multiple tabs in the workboofk that have an individual name in the tab title. I would like the macro to search the entire workbook and delete all tabs that have a designated name as part of the tab title. The macro should look in a specified cell for a name and then search the workbook and delete all tabs that contains that name.

The other macro is similar to the first but instead of searching for tabs to delete it would search the workbooks pages and delete all rows that contain the individuals name.

I have included a example of the workbook i am dealing with. In this example i would like to delete all tabs that contain the name "dean Mcghee" and search the other remaining pages of the workbook and delete every row that has the same name in it.

Is this possible?

[dflak]

This code makes a couple of assumptions:
1. Column A on each sheet contains the last row of data
2. The name appears only in column A or B

Please Login or Register  to view this content.

[chriswrcg]

I have this code and it is working great except for one small thing. It is deleting all rows containing the name and all tabs that are just the persons name, however I also have some worksheets in the workbook that are "weekly + the persons name". Those tabs are being ignored. What can I add to the code to also include every tab in the workbook that has the word weekly in front of the persons name?

Please Login or Register  to view this content.