Silverhorne
New Member
- Joined
- Feb 21, 2015
- Messages
- 42
- Office Version
- 365
- 2019
- Platform
- Windows
Good day,
I have been working to simplify a log that is used by a lot of people I work with. I originally built it years ago with helper columns and need to get rid of them.
I have 2 items I need to solve but will post the second one in a different post.
Item 1:
I have a massive log, column B has unique items. Columns D-K have the initials of the person that worked on that part of the item.
What needs to happen is the report needs to list the items from the log that match what has been entered in "E1" of the report to "M" of the log.
Any help is greatly appreciated!
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
I have been working to simplify a log that is used by a lot of people I work with. I originally built it years ago with helper columns and need to get rid of them.
I have 2 items I need to solve but will post the second one in a different post.
Item 1:
I have a massive log, column B has unique items. Columns D-K have the initials of the person that worked on that part of the item.
What needs to happen is the report needs to list the items from the log that match what has been entered in "E1" of the report to "M" of the log.
Any help is greatly appreciated!
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Current Helper column | Unique Items | Part 1 | Part 2 | Part 3 | Part 4 | Part 5 | Part 6 | Part 7 | Part 8 | REPORT | Current Helper column | |||
2 | Item 1 | AA | AA | AA | AA | BB | BB | BB | BB | AA/BB | |||||
3 | 1 | Item 2 | BB | BB | BB | BB | BB | BB | BB | BB | Report 1 | BB | |||
4 | Item 3 | CC | DD | CC | DD | CC | DD | CC | DD | CC/DD | |||||
5 | 2 | Item 4 | ABC | E | ABC | E | ABC | DD | E | ABC | Report 1 | ABC/E/DD | |||
6 | 3 | Item 5 | FF | GG | HH | II | JJ | KK | LL | MMM | Report 1 | FF/GG/HH/II/JJ/KK/LL/MMM |
<tbody>
</tbody>
LOG
Worksheet Formulas
<tbody> </tbody> |
<tbody>
</tbody>
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Item | Parts | Report 1 | ||
2 | Item 2 | BB | |||
3 | Item 4 | ABC/E/DD | |||
4 | Item 5 | FF/GG/HH/II/JJ/KK/LL/MMM | |||
5 | |||||
6 |
<tbody>
</tbody>
Report
Worksheet Formulas
<tbody> </tbody> |
<tbody>
</tbody>
Last edited: