Delete name from Sheet1 as I type same name in cell of Sheet2

[Closed]
Report
Posts
8
Registration date
Thursday March 13, 2014
Status
Member
Last seen
March 15, 2014
-
Posts
8
Registration date
Thursday March 13, 2014
Status
Member
Last seen
March 15, 2014
-
I have a list of 10,000 unique people with corresponding statistics on a worksheet. These are also included on additional worksheets into smaller subcategories, so they are listed twice: once on the large list, once on one of the smaller lists. I want to be able to type that name on a third sheet (whether it's the first few letters, or entire cell exactly) in each cell within a block or designated area of cells ("named"?, i.e., A2:S100) that once manually entered into a cell within that block on the third sheet (realizing it has to be exact), that entry/name is removed from the other larger and small lists from aforementioned Sheets 1 & 2. (If can only be done with one other worksheet, i.e. larger list, that is fine).

Example: I manually type "Miller, John" in B3 of Worksheet 3, and upon "hitting enter", macro or formulas remove "Miller, John" from Worksheet 1 or 2, or hopefully both.

Thanks!

1 reply

Posts
8
Registration date
Thursday March 13, 2014
Status
Member
Last seen
March 15, 2014

Oh yeah....I want to do this for multiple names, not just one, within a certain area (and including all cells) on Worksheet 3, say A2:S100. Thanks!