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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Joe[/TD]
[TD]10:00[/TD]
[TD][/TD]
[TD]10:00[/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD]9:00[/TD]
[TD]9:00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD][/TD]
[TD]11:00[/TD]
[TD]12:00[/TD]
[/TR]
[TR]
[TD]Kate[/TD]
[TD]13:00[/TD]
[TD][/TD]
[TD]9:00[/TD]
[/TR]
[TR]
[TD]Sam[/TD]
[TD]12:00[/TD]
[TD]13:00[/TD]
[TD]13:00[/TD]
[/TR]
</tbody>[/TABLE]

Sheet2
[TABLE="width: 300"]
<tbody>[TR]
[TD]Mark[/TD]
[TD]9:00[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]10:00[/TD]
[/TR]
[TR]
[TD]Sam[/TD]
[TD]12:00[/TD]
[/TR]
[TR]
[TD]Kate[/TD]
[TD]13:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet3
[TABLE="width: 300"]
<tbody>[TR]
[TD]Mark[/TD]
[TD]9:00[/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD]11:00[/TD]
[/TR]
[TR]
[TD]Sam[/TD]
[TD]13:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sheet4
[TABLE="width: 300"]
<tbody>[TR]
[TD]Kate[/TD]
[TD]9:00[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]10:00[/TD]
[/TR]
[TR]
[TD]David[/TD]
[TD]12:00[/TD]
[/TR]
[TR]
[TD]Sam[/TD]
[TD]13:00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.