its_me_renan
Board Regular
- Joined
- Dec 18, 2011
- Messages
- 70
Please help me to make a program using excel which I can use in my current work. As you can see I have a series of inputs from column A to column F. What I want to happen is when I input a tag or series of tags on column H starting at H3, it will scan all tags at column C and all similar tags will copied together with their corresponding details to column J to column O. Thank you. See below sample.
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
1 | Work order | Work Description | Tag | Area | Require Bypass? | Shutdown | Input Tag HERE! | Work order | Work Description | Tag | Area | Require Bypass? | Shutdown | ||
2 | |||||||||||||||
3 | 60166 | Inspetion of Mixer | PE-Y-7601 | P1 | yes | yes | PE-Y-7609 | 60174 | Declogging of lines | PE-Y-7609 | P3 | yes | no | ||
4 | 60170 | Inspetion of Belt | PE-Y-7607 | P2 | yes | no | PE-Y-7730 | 60182 | Cleaning of filter | PE-Y-7730 | P5 | no | no | ||
5 | 60174 | Declogging of lines | PE-Y-7609 | P3 | yes | no | PP-Y-7772 | 60186 | Replacement of Valves | PP-Y-7001 | P4 | yes | yes | ||
6 | 60178 | Manual Barring of compressor | PE-Y-7610A | P4 | no | yes | PP-Y-7001 | ||||||||
7 | 60182 | Cleaning of filter | PE-Y-7730 | P5 | no | no | PP-Y-7202 | ||||||||
8 | 60186 | Replacement of Valves | PP-Y-7001 | P4 | yes | yes | |||||||||
9 | 60190 | Sampling of Vessels | PP-Y-7002 | P5 | no | yes | |||||||||
10 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>