+ Reply to Thread
Results 1 to 5 of 5

Exclude Blanks

  1. #1
    Registered User
    Join Date
    11-05-2014
    Location
    SF
    MS-Off Ver
    Excel 2010
    Posts
    39

    Exclude Blanks

    Here is my code :

    Please Login or Register  to view this content.
    I need the info to copy only if there is something in the cell. The blanks are all copying right now, and it's messing me up.

    Thanks!

  2. #2
    Registered User
    Join Date
    11-05-2014
    Location
    SF
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Exclude Blanks

    Here is the official WB.
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Exclude Blanks

    Try this
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    11-05-2014
    Location
    SF
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Exclude Blanks

    I tried that... maybe it's because I'm changing the match columns? Say I wanted to change them to F, I, Q, T. What would I have to change except for all B,C,D,E's become F,I,Q,T?

    When I do it, it runs and populates pretty much every row. I don't know why... Here is my code after the change.

    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Exclude Blanks

    Try to change Count = 2 to Count = 3
    I think it is the problem..
    I prefer to attach the original wb..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to exclude negative numbers and blanks
    By Hackett in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2015, 08:18 AM
  2. Dynamic Ranges vs. Formulas that exclude blanks?
    By amartino44 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2013, 02:04 PM
  3. Exclude blanks from formula
    By ads100 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-07-2012, 06:17 PM
  4. Replies: 1
    Last Post: 07-19-2012, 05:09 PM
  5. Excel 2007 : MIN, AVE, MAX values but exclude blanks
    By Quagga in forum Excel General
    Replies: 7
    Last Post: 07-15-2010, 02:29 PM

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