Copying non blank cells to another sheet

[xerpar]

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

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>

Sheet3

Mark	9:00
David	11:00
Sam	13:00

<tbody>
</tbody>

Sheet4

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.

 

[Armando Montes]

Hi, might try:
1. Copy sheet 1 all data to each of the other sheets and:
Delete Blank Rows in Excel, Remove Blank Cells in Excel | Chandoo.org - Learn Microsoft Excel Online
Finally sort time columns.

 

[xerpar]

Cheers for the reply. I need to keep the blank cells. The whole rows aren't blank just some cells in some rows. And i really need to have it done automatically as the times will change every week. I'm half way there with formulas just getting a little stuck.