+ Reply to Thread
Results 1 to 5 of 5

Copy top cell post autofilter and re-apply autofilter based on cell value

  1. #1
    Registered User
    Join Date
    02-23-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    26

    Copy top cell post autofilter and re-apply autofilter based on cell value

    Hi All,

    I'm a complete novice and once again have been playing around with VBA (enjoy a challenge but should know better by now...) and have come to up empty handed and confused.

    I can select the top cell in column "F" after filtering by multiple columns using VBA and arrays, but now want to I want to use the top cell in column "F" to search for all other equipment that uses this item.

    e.g. remove filter, and reapply autofilter to column "F" based on selected cell as per below VBA

    Note: Row 1 contains command buttons and row 2 Headers.


    Please Login or Register  to view this content.

    Any advise that helps steer me in the right direction would be greatly appreciated.

    Cheers,
    gpato

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Copy top cell post autofilter and re-apply autofilter based on cell value

    Hi,
    Not sure to understand what you are trying to achieve there.
    Can you post a sample workbook to help us understand.

    PS : avoid using .Select in your code has it slows it down.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Copy top cell post autofilter and re-apply autofilter based on cell value

    I'm also not sure. Here's a guess.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  4. #4
    Registered User
    Join Date
    02-23-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Copy top cell post autofilter and re-apply autofilter based on cell value

    Sample.xlsmThanks GC Excel,

    I've now replicated how I filter the first filter criteria as per below.

    Please Login or Register  to view this content.
    Attached sample workbook to help.

    I'm trying to re-filter results in column F to see what other equipment uses that part number.


    Thanks
    gpato

  5. #5
    Registered User
    Join Date
    02-23-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Copy top cell post autofilter and re-apply autofilter based on cell value

    Thanks AlphaFrog. AWESOME.

    Just had to change filter Field:=6


    Will add all inventory and keep playing.

    Appreciate your time and assistance.

    gpato

+ 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. autofilter based on cell input (=>)
    By ln2012 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2013, 03:40 AM
  2. Autofilter based on a cell value
    By ccsmith in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2011, 09:45 AM
  3. VBA autofilter based on cell value
    By 50pingviner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-13-2010, 12:47 PM
  4. Cell content based on autofilter
    By Sp00k in forum Excel General
    Replies: 1
    Last Post: 01-10-2007, 02:59 PM
  5. [SOLVED] Copy to visible cell after Autofilter
    By Hank in forum Excel General
    Replies: 4
    Last Post: 07-06-2006, 11:35 AM

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