Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Copying non blank cells to another sheet

  1. #1
    New Member
    Join Date
    Feb 2014
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Copying non blank cells to another sheet

    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

    Sheet2
    Mark 9:00
    Joe 10:00
    Sam 12:00
    Kate 13:00
    Sheet3
    Mark 9:00
    David 11:00
    Sam 13:00
    Sheet4
    Kate 9:00
    Joe 10:00
    David 12:00
    Sam 13:00

    Anyone be able to help with this? Prefer non macro, as quite often macros are disabled.

  2. #2
    Board Regular
    Join Date
    Sep 2008
    Posts
    505
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copying non blank cells to another sheet

    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.

  3. #3
    New Member
    Join Date
    Feb 2014
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Copying non blank cells to another sheet

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •