+ Reply to Thread
Results 1 to 2 of 2

how to filter out blank rows in to the next worksheet

  1. #1
    Registered User
    Join Date
    03-23-2021
    Location
    Farmington, MI
    MS-Off Ver
    microsoft 2019
    Posts
    1

    Question how to filter out blank rows in to the next worksheet

    I am currently trying to make a spreadsheet for my company and I need some help.
    Is there a way to conditionally format a table in sheet one so if the table is not finished (or cell is left blank) it would show on the next worksheet?

    For example I have a incoming product sheet where the inventory needs to be signed and approved. if in the first sheet, the cell for the signature is not filled out, it would show up on the next sheet as a reminder.

    My explanation is not great but I am trying to filter out the unfinished rows in a very large collection of data to the next sheet. Is there an efficient way to do so in excel?


    Thanks

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,454

    Re: how to filter out blank rows in to the next worksheet

    Hi and welcome.

    One simple way would be to use a helper column in the first sheet to apply a unique number to the rows with no signature and then lookup formulas on the next sheet to show those.

    Note this would work to show them only. When it comes to updating them with the signature you'd have to add that on the first sheet rather than the second.

    If you need to be able to update them on the second sheet then you'd probably be looking at a VBA solution.

    Attach a small desensitized version of your workbook and I can show you what I mean by the helper column approach.

    BSB

+ 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. vba advanced filter blank rows for printing
    By tim_p in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2020, 05:50 PM
  2. Copy/Filter Results That Are Not Blank/Zero From One Worksheet to Another
    By davis909 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2017, 02:46 AM
  3. [SOLVED] VBA to Filter out Blank Cells, copy /paste into another worksheet
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2014, 03:36 AM
  4. [SOLVED] VBA Advanced Filter - Keep Blank Rows and put them at the top
    By BeachRock in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2013, 03:22 PM
  5. [SOLVED] Delete blank rows after filter - if no blank rows exit sub
    By cmb80 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2012, 10:00 AM
  6. Advanced Filter - Blank Rows
    By karl_009 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-30-2008, 06:35 AM
  7. Filter Shows Blank Rows in Selection
    By Progress2007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2008, 07:51 AM

Tags for this Thread

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