Silverhorne
New Member
- Joined
- Feb 21, 2015
- Messages
- 42
- Office Version
- 365
- 2019
- Platform
- Windows
Good day,
I have been trying to clean up my spread sheet by removing helper columns and can't figure out how o do it.
I have a main log with all of my data and another sheet as a request. I am trying to populate the request based on the contents in a specific cell matching the same contents on another sheet over multiple columns, then returning the data from another column. I would like to do this with formulas and not VBA. My original spreadsheet has 10 helper columns that I need to get rid of; other people keep deleting the contents and adding rows, not knowing the formulas are there.
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
<colgroup><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
I have been trying to clean up my spread sheet by removing helper columns and can't figure out how o do it.
I have a main log with all of my data and another sheet as a request. I am trying to populate the request based on the contents in a specific cell matching the same contents on another sheet over multiple columns, then returning the data from another column. I would like to do this with formulas and not VBA. My original spreadsheet has 10 helper columns that I need to get rid of; other people keep deleting the contents and adding rows, not knowing the formulas are there.
A | B | C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|---|---|
1 | Data | ||||||||
2 | |||||||||
3 | Helper | ||||||||
4 | Drawing | Line# | Person | 6am | Noon | 6pm | Midnight | ||
5 | Iso 54 | water | Bill | ||||||
6 | 1 | Iso 54 | gas | Frank | Request 1 | ||||
7 | Iso 52 | nitrogen | Dave | ||||||
8 | 2 | Iso 54 | gas | Dave | Request 1 | ||||
9 | Iso 54 | nitrogen | Frank | ||||||
10 | 3 | Iso 54 | water | Frank | Request 1 | ||||
11 | Iso 54 | water | Frank | ||||||
12 | Iso 52 | nitrogen | Frank | ||||||
13 | Iso 53 | nitrogen | Dave | ||||||
14 | 4 | Iso 54 | nitrogen | Bill | Request 1 | ||||
15 | Iso 53 | nitrogen | Dave | ||||||
16 | Iso 53 | water | Bill | ||||||
17 | 5 | Iso 53 | water | Bill | Request 1 | ||||
18 | Iso 54 | gas | Dave | ||||||
19 | Iso 52 | gas | Bill | ||||||
20 | Iso 52 | nitrogen | Bill | ||||||
21 | 6 | Iso 54 | gas | Frank | Request 1 | ||||
22 | Iso 53 | gas | Dave | ||||||
23 | Iso 53 | water | Bill | ||||||
24 | Iso 54 | nitrogen | Frank | ||||||
25 | 7 | Iso 52 | water | Dave | Request 1 | ||||
26 | Iso 54 | water | Bill |
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Log
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Request 1 | |||||
2 | ||||||
3 | ||||||
4 | Helper | Drawing | Line# | Person | ||
5 | 1 | Iso 54 | gas | Frank | ||
6 | 2 | Iso 54 | gas | Dave | ||
7 | 3 | Iso 54 | water | Frank | ||
8 | 4 | Iso 54 | nitrogen | Bill | ||
9 | 5 | Iso 53 | water | Bill | ||
10 | 6 | Iso 54 | gas | Frank | ||
11 | 7 | Iso 52 | water | Dave | ||
12 | ||||||
13 | ||||||
14 | ||||||
15 | ||||||
16 | ||||||
17 | ||||||
18 | ||||||
19 | ||||||
20 | ||||||
21 |
<colgroup><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Request
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>