Results 1 to 4 of 4

Filtering with blank rows between data

Threaded View

  1. 02-26-2015, 02:57 AM #1
    Frodoe
    Frodoe is offline
    Registered User
    Join Date
    02-12-2015
    Location
    South Africa
    MS-Off Ver
    10
    Posts
    31

    Filtering with blank rows between data

    Hi

    In the attached doc in the assortment sheet I am looking to filter data.
    Example. If I were to create a filter and select supplier (column I). I would like to view all rows applicable to this particular supplier.
    At the moment I am only able to view the rows up to the end of the 1st months data.

    The problem is the sheet is setup by month where I have gaps and spaces between each month. These spaces are required as new data is constantly added.

    Any suggestions?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filtering Data With Any Blank Columns
    By mb5280 in forum Excel General
    Replies: 3
    Last Post: 10-29-2013, 02:44 PM
  2. How to create a macro to insert blank rows and copy data into blank rows?
    By zodiack101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2013, 01:18 PM
  3. Data Filtering with blank rows
    By leungf in forum Excel General
    Replies: 2
    Last Post: 03-01-2012, 10:37 AM
  4. Resolved >>> FIltering Non blank Rows
    By JOERIDEOUT in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-19-2011, 05:43 AM
  5. Filtering blank rows from a column
    By IB4OU in forum Excel General
    Replies: 2
    Last Post: 01-30-2007, 06:46 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1