+ Reply to Thread
Results 1 to 6 of 6

Skip blank cells

  1. #1
    Registered User
    Join Date
    02-10-2012
    Location
    Manila,Philippines
    MS-Off Ver
    Excel 2007, 2010
    Posts
    13

    Skip blank cells

    Hi everyone,

    Would like to ask your recommendation using a simple vba code on how to ignore a blank cell and copying those with populated cells.

    Example:

    Sheet 1

    A
    1 100
    2 200
    3
    4
    5 150
    6
    7 200

    Would end up like this..


    Sheet 2

    A
    1 100
    2 200
    3 150
    4 200
    5
    6
    7


    Thanks a lot in advance!

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Skip blank cells

    If it isn't essential to keep the same order, then just sort the column - that will put the blanks to the bottom.

  3. #3
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Skip blank cells

    Try

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    02-10-2012
    Location
    Manila,Philippines
    MS-Off Ver
    Excel 2007, 2010
    Posts
    13

    Re: Skip blank cells

    Appreciate your response Mallycat

    Actually, it still does need to keep it's order depends on who goes first. Not from smallest value to largest or vise versa.

    Also, it comes with a copying program from sheet 1 then automatically ignore the unpopulated cells when it is copied to sheet 2. Is it possible?

    Thanks again!

  5. #5
    Registered User
    Join Date
    02-10-2012
    Location
    Manila,Philippines
    MS-Off Ver
    Excel 2007, 2010
    Posts
    13

    Re: Skip blank cells

    Wow! works perfectly..

    Thanks a lot for your help JieJenn. Appreciate it

  6. #6
    Registered User
    Join Date
    02-10-2012
    Location
    Manila,Philippines
    MS-Off Ver
    Excel 2007, 2010
    Posts
    13

    Re: Skip blank cells

    I tried using it for other columns by changing the range but it seems doesn't work? May i know why is that so?

    Many thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1