+ Reply to Thread
Results 1 to 3 of 3

Auto Filter issue with VLOOKUP data in column

  1. #1
    Registered User
    Join Date
    01-13-2021
    Location
    Houston, TX
    MS-Off Ver
    Excel version 1803
    Posts
    2

    Auto Filter issue with VLOOKUP data in column

    I have a workbook where I have a tab with an excel data dump from another program. I have another tab to sort and group that data using VLOOKUP formulas. I have the VLOOKUP data grouped by the rows that contain the pertinent data for the main sort. Each of these groups are separated by a blank row to add ease of viewing. My issue is that now I have added auto filter buttons to the column headers, but the filter only recognizes the uppermost group of data. It stops the filter at the blank row. if I remove the blank row it filters just fine. Why does it not recognize the cell in the column as a "blank" for the auto filter and keep pulling data to the bottom of the page?

    If I need to explain better I can try. For me to attach an example workbook it will be difficult due to most all the data being proprietary.
    Last edited by BSGordon; 01-14-2021 at 04:11 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Auto Filter issue with VLOOKUP data in column

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    If necessary vreate a small book with some mocked up data showing what went wrong and expected results

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    01-13-2021
    Location
    Houston, TX
    MS-Off Ver
    Excel version 1803
    Posts
    2

    Re: Auto Filter issue with VLOOKUP data in column

    Please see the attached sample sheet with the filtering issue.
    Attached Files Attached Files

+ 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 code review for Auto filter issue
    By sudhansu121 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-07-2021, 10:55 AM
  2. Auto vlookup and Auto filter based on condition
    By Power Puneeth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2020, 01:19 PM
  3. Issue copying visible cells after auto filter
    By Ianmacros in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2019, 08:13 PM
  4. [SOLVED] VBA macros to auto filter copy and past the data by column
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2019, 05:37 AM
  5. [SOLVED] Data into multiple worksheets based on column in Excel and apply auto filter and freeze
    By skumarlingam in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-28-2016, 04:50 PM
  6. Replies: 4
    Last Post: 03-06-2015, 03:40 AM
  7. Auto Filter issue
    By bizmoh in forum Excel General
    Replies: 1
    Last Post: 07-14-2008, 01:04 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