+ Reply to Thread
Results 1 to 2 of 2

Horizontal filter

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    27

    Horizontal filter

    Hi,

    I need a VBA to do some sort of horiztonal filter in Excel. I assume the only real way of doing this is by hiding columns which is fine.

    The code needs to read the input from F1 and hide any columns where this input does not appear in cell 1 of that column i.e. only leave the columns which match the corresponding input.

    - Please only hide columns from G onwards (the code needs to read to the end of the non blank columns as I need to keep adding data columns)

    See screenshot below - in this instance the input is "GCM" in F1 so columns H, I and J would need to be hidden but columns K and L would remain visible.

    Thanks

    JackCapture1.JPG

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Horizontal filter

    Something like. (not tested)

    Please Login or Register  to view this content.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

+ 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: 9
    Last Post: 09-19-2012, 05:31 AM
  2. Help with Horizontal filter code
    By phschris1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2009, 08:29 PM
  3. macro horizontal count after filter
    By gtg653t in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2007, 01:05 AM
  4. horizontal filter macro
    By gtg653t in forum Excel General
    Replies: 0
    Last Post: 12-03-2007, 12:25 PM
  5. [SOLVED] Horizontal filter
    By Wallace in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2006, 06:40 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