Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,786
- Office Version
- 365
- Platform
- Windows
I hope I can explain this ok! I need the code to firstly look at column C on Sheet 1. Where there are rows with the same data in C I need the code to look at column AB and see that both the numbers/text in column A & B on sheet 2 are in the rows if not highlight the rows.
i.e
The word example is in 4 rows it then looks at column AB and sees the word ABC it looks for ABC on sheet 2 and because DEF is next to ABC on sheet 2 but not in AB on sheet 1 it highlights the row.
If you look at example 3 both STU and VWX are in the range so it leaves the rows white. Thanks
i.e
The word example is in 4 rows it then looks at column AB and sees the word ABC it looks for ABC on sheet 2 and because DEF is next to ABC on sheet 2 but not in AB on sheet 1 it highlights the row.
If you look at example 3 both STU and VWX are in the range so it leaves the rows white. Thanks
| Excel Workbook | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | A | B | C | D-AA | AB | ||
| 2 | Various data | Various data | Example | Various data | ABC | ||
| 3 | Various data | Various data | Example | Various data | ABC | ||
| 4 | Various data | Various data | Example | Various data | ABC | ||
| 5 | Various data | Various data | Example | Various data | ABC | ||
| 6 | Various data | Various data | Example1 | Various data | JKL | ||
| 7 | Various data | Various data | Example1 | Various data | JKL | ||
| 8 | Various data | Various data | Example1 | Various data | JKL | ||
| 9 | Various data | Various data | Example1 | Various data | JKL | ||
| 10 | Various data | Various data | Example1 | Various data | JKL | ||
| 11 | Various data | Various data | Example2 | Various data | PQR | ||
| 12 | Various data | Various data | Example2 | Various data | PQR | ||
| 13 | Various data | Various data | Example2 | Various data | PQR | ||
| 14 | Various data | Various data | Example2 | Various data | PQR | ||
| 15 | Various data | Various data | Example2 | Various data | PQR | ||
| 16 | Various data | Various data | Example3 | Various data | STU | ||
| 17 | Various data | Various data | Example3 | Various data | VWX | ||
| 18 | Various data | Various data | Example3 | Various data | STU | ||
| 19 | Various data | Various data | Example3 | Various data | STU | ||
Sheet1 | |||||||
| Excel Workbook | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | Part 1 | Part 2 | ||
| 2 | ABC | DEF | ||
| 3 | GHI | JKL | ||
| 4 | MNO | PQR | ||
| 5 | STU | VWX | ||
Sheet2 | ||||
