Hello
I'm trying to develop a sheet to display peoples names and times from one sheet to another but on the 2nd, 3rd, & 4th sheet to skip blank cells, and preferably sorted by time.
Example:
Sheet1
<tbody>
</tbody>
Sheet2
<tbody>
</tbody>Sheet3
<tbody>
</tbody>Sheet4
<tbody>
</tbody>
Anyone be able to help with this? Prefer non macro, as quite often macros are disabled.
I'm trying to develop a sheet to display peoples names and times from one sheet to another but on the 2nd, 3rd, & 4th sheet to skip blank cells, and preferably sorted by time.
Example:
Sheet1
Joe | 10:00 | 10:00 | |
Mark | 9:00 | 9:00 | |
David | 11:00 | 12:00 | |
Kate | 13:00 | 9:00 | |
Sam | 12:00 | 13:00 | 13:00 |
<tbody>
</tbody>
Sheet2
Mark | 9:00 |
Joe | 10:00 |
Sam | 12:00 |
Kate | 13:00 |
<tbody>
</tbody>
Mark | 9:00 |
David | 11:00 |
Sam | 13:00 |
<tbody>
</tbody>
Kate | 9:00 |
Joe | 10:00 |
David | 12:00 |
Sam | 13:00 |
<tbody>
</tbody>
Anyone be able to help with this? Prefer non macro, as quite often macros are disabled.