This should be easy, so it's no wonder I'm having trouble with it.
In column A I have a list of main categories
In column B I have a list of sub-categories
In column C I have a list the main catagories that each of the sub-categories in column B belongs to.
All of the values in column A and B are unique
Many of the values in column C are dupicate (since a main catagory could have several sub-catagories).
I would like for 2 things to happen when the user deletes a main catagory
1. The name of the main catagory gets deleted from colunm A.
2. Each instance of the main category name in column C will also be deleted, as well as the corresponding sub-category in column B.
Not sure if this is clear or not, but please see the attached workbook. It shows a "before" and "after" of what I'm looking to achieve.
thanks in advance!
Bookmarks