+ Reply to Thread
Results 1 to 5 of 5

Skip Row if result is blank

  1. #1
    Registered User
    Join Date
    02-05-2013
    Location
    NSW Australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Skip Row if result is blank

    Hi,
    Thanks in advance for your assistance.

    I have a workbook which contains a master document sheet and 14 worksheets with various if(and or vlookup statements to extract the data as we need it at our centre.

    I wasn't able to sort the data alphabetically with iferror leave cell black, so I changed it to if error "zz". I am now having to sort 14 sheets A-Z every time I make a change to my workbook...very time consuming and frustrating. I'm looking for a way to not have to sort my worksheets, to have it done automatically or is there a way to skip rows if the data doesn't match the formula? I don't have any experience in Macros

    I have removed a lot of the pages from my workbook example. The sheet that I am trying to skip rows is the 'Dolphin Chn' one. Data is coming from the other sheets. I have used conditional formatting to make ZZ entries white, so they won't be visible.

    2014 Master Document example.xlsx

    Thank you,
    Sarah
    Last edited by peterpan1279; 03-23-2014 at 07:51 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,207

    Re: Skip Row if result is blank

    Hi and welcome to the forum sara

    Try this approach. In a blank column in Preschool sheet (I used I), copy this into I2 an copy down...
    =IF(B2="",G1,G1+1)

    Then on Dolphin sheet use this...
    =IFERROR(INDEX('Preschool List'!$B:$F,MATCH(ROW($A1),'Preschool List'!$I:$I,0),MATCH(Table19[[#Headers],[Monday]],'Preschool List'!$B$1:$F$1,0)),"")

    This last part needs work, but I am out of time right now, I will be back soon
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Skip Row if result is blank

    Hi,

    I have attached a solution.

    I hope this helps
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-05-2013
    Location
    NSW Australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Skip Row if result is blank

    Ajryan88,

    I officially love you!! This worked perfectly. My colleagues had to come check I was ok after an excited squeal was heard throughout the office.

    Thanks so much!

  5. #5
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Skip Row if result is blank

    Hahahaha I'm glad I was able to help

    Please don't forget to click on the * next to my post to say thanks

+ 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. Replies: 2
    Last Post: 10-18-2013, 11:18 AM
  2. index match, ..... skip result if blank value ...... jump to next match
    By gehawk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2013, 04:42 AM
  3. Skip Blank rows
    By Bmxerdude2087 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2012, 11:09 PM
  4. Using If .. Then to skip a blank combo box in a For...Next
    By Squirrel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2011, 10:14 PM
  5. skip blank cells
    By Seroleh in forum Excel General
    Replies: 16
    Last Post: 05-28-2009, 02:21 AM

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