jmckeone
Well-known Member
- Joined
- Jun 3, 2006
- Messages
- 550
I want to be able to examine a range of cells for a value in another range of items so that rows meeting that criteria will be deleted. Reason I showed both text string and numbers is that I'd like to know how to use both approaches.
Book6 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Value | Color | ||||
2 | 2500 | white | ||||
3 | 1236 | red | ||||
4 | 4897 | pink | ||||
5 | 5712 | black | ||||
6 | 9425 | blue | ||||
7 | 1425 | brown | ||||
8 | 9974 | purple | ||||
9 | 2500 | yellow | ||||
10 | 7419 | tan | ||||
11 | ||||||
12 | ||||||
13 | RemoveValue | RemoveColor | ||||
14 | 2500 | green | ||||
15 | 1425 | blue | ||||
16 | 9974 | yellow | ||||
Sheet1 |