trebor1956
Board Regular
- Joined
- Jul 2, 2015
- Messages
- 100
- Office Version
- 2013
- Platform
- Windows
Hi, I have 5 worksheets (loop 1, loop 2, loop 3, loop 4 and loop 5) with similar info but in differing order. I would like to for instance extract every occurrence (whole line) where column D contains "MCP" from each of the 5 worksheets and put into a new worksheet called MCP listing all occurrences of "MCP". Other than "MCP" there are 4 other definitions (Smoke, Heat, Sounder, I/O) I would like to extract to their own new worksheets.
Below is a copy of the loop 1 w/sheet as an example. I had a go at Hlookup but struggled.
Below is a copy of the loop 1 w/sheet as an example. I had a go at Hlookup but struggled.
Loop | Address | Location | Type | Zone |
1 | 0001 | Main entrance | MCP | 1 |
1 | 0002 | Main entrance | Smoke | 1 |
1 | 0003 | Entrance doors | I/O | 1 |
1 | 0004 | Family room | Sounder | 2 |
1 | 0005 | Family room | Smoke | 2 |