Hello,
My employees work on multiple projects, they use excel to record their hours. We currently have 10+ projects but an employee may only be working on any 5 of those. Each employee has their own excel spreadsheet (stored on sharepoint- online 365)
I would like to be able to automatically hide columns /projects(3 columns per project) on sheet 2, that the employee is not working when the value under the Assigned heading on Sheet 1 (see C2-C13 etc) for a project is "N". Column C has a data validated function to be either "blank", "Y" or "N"
Sheet 1 below
<tbody>
</tbody>
Sheet 2 below
<tbody>
</tbody>
Can you please assist me with appropriate coding to complete this function, your assistance is greatly appreciated.
Alex
The result of the coding would be as follows:
<tbody>
</tbody>
My employees work on multiple projects, they use excel to record their hours. We currently have 10+ projects but an employee may only be working on any 5 of those. Each employee has their own excel spreadsheet (stored on sharepoint- online 365)
I would like to be able to automatically hide columns /projects(3 columns per project) on sheet 2, that the employee is not working when the value under the Assigned heading on Sheet 1 (see C2-C13 etc) for a project is "N". Column C has a data validated function to be either "blank", "Y" or "N"
Sheet 1 below
A | B | C | Notes:corresponding column on sheet 2 to hide | ||
1 | Employee: | John Smith | |||
2 | Project Name | Assigned | |||
3 | T500 | Y | |||
4 | T501 | N | F-H | ||
5 | T502 | Y | |||
6 | T503 | N | L-N | ||
7 | T504 | Y | |||
8 | T505 | Y | |||
9 | T506 | N | U-W | ||
10 | T507 | N | X-Z | ||
11 | T508 | Y | |||
12 | T509 | N | AD-AF | ||
13 | T510 | Y | |||
14 | Etc |
<tbody>
</tbody>
Sheet 2 below
a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | |
1 | Project | T500 (Col:C-E) | T501 (Col:f-h) | T502 (Col: i - K | T503 (Col: L-N | T504 (Col: O-Q) | T505(Col: R-T) | T506 (Col: U-W) | ETC | ||||||||||||||||
2 | Date | Start | Finish | Total | Start | Finish | Total | Start | Finish | Total | Start | Finish | Total | Start | Finish | Total | Start | Finish | Total | Start | Finish | Total | |||
3 | |||||||||||||||||||||||||
4 | |||||||||||||||||||||||||
5 | |||||||||||||||||||||||||
6 | |||||||||||||||||||||||||
7 | |||||||||||||||||||||||||
8 |
<tbody>
</tbody>
Can you please assist me with appropriate coding to complete this function, your assistance is greatly appreciated.
Alex
The result of the coding would be as follows:
a | b | c | d | e | i | j | k | o | p | q | r | s | t | x | y | |
1 | Project | T500 (Col:C-E) | T502 (Col: i - K | T504 (Col: O-Q) | T505(Col: R-T) | ETC | ||||||||||
2 | Date | Start | Finish | Total | Start | Finish | Total | Start | Finish | Total | Start | Finish | Total | |||
3 | ||||||||||||||||
4 | ||||||||||||||||
5 | ||||||||||||||||
6 | ||||||||||||||||
7 | ||||||||||||||||
8 |
<tbody>
</tbody>