+ Reply to Thread
Results 1 to 2 of 2

Please help!extract rows from a sheet if one of the columns is not blank to another sheet

  1. #1
    Registered User
    Join Date
    11-12-2019
    Location
    Geneva
    MS-Off Ver
    1902
    Posts
    3

    Lightbulb Please help!extract rows from a sheet if one of the columns is not blank to another sheet

    Please help, looking for an array or v look up solution.

    I have a mastersheet with data and need to extract rows from this sheet if one of the columns (Event status) has any text in it to another sheet. The master sheet has been extracted from a query and thus refreshes.
    Attached Files Attached Files
    Last edited by yshera; 11-12-2019 at 10:58 AM.

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,075

    Re: How to extract rows from a sheet, if one of the columns is not blank to another sheet

    Check the yellow banner above.
    Click the * 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. [SOLVED] VBA to extract rows that contain blank cells in specific columns
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-13-2016, 07:08 AM
  2. To delete blank columns and rows in a different sheet
    By naveenhs5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2014, 04:21 PM
  3. Replies: 10
    Last Post: 08-14-2013, 03:32 PM
  4. Replies: 0
    Last Post: 02-22-2013, 09:23 AM
  5. Replies: 1
    Last Post: 12-09-2012, 06:50 AM
  6. Replies: 1
    Last Post: 05-13-2010, 09:50 AM
  7. Macro to copy rows from 1 sheet into the next blank row on a different sheet
    By kpratico in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2010, 01:16 PM

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