+ Reply to Thread
Results 1 to 4 of 4

Multiple Row Filters based linked to Button and Drop down menu

  1. #1
    Forum Contributor
    Join Date
    09-09-2008
    Location
    Middlesbrough, England
    MS-Off Ver
    2007
    Posts
    174

    Multiple Row Filters based linked to Button and Drop down menu

    Hi,

    I have a worksheet which shows a Monthly, Weekly & Daily view. The data is then split into a further 3 views eg:

    {Monthly In-house} {Monthly Outsource} {Monthly Combined}.

    I would like to be able to use a combination of a button & drop down menu to provide the selected view.

    IE: I select Inhouse button and then Monthly within drop down it will only show in house monthly. Is this possible?

    Attached is a copy of the worksheet.Sample.xlsm

  2. #2
    Forum Contributor
    Join Date
    09-09-2008
    Location
    Middlesbrough, England
    MS-Off Ver
    2007
    Posts
    174

    Re: Multiple Row Filters based linked to Button and Drop down menu

    Any idea or suggestions?

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Multiple Row Filters based linked to Button and Drop down menu

    Unfortunately, all those merged cells and skipped rows make your sheet extremely difficult to work with.
    Ben Van Johnson

  4. #4
    Forum Contributor
    Join Date
    09-09-2008
    Location
    Middlesbrough, England
    MS-Off Ver
    2007
    Posts
    174

    Re: Multiple Row Filters based linked to Button and Drop down menu

    Thanks may have to accept defeat

+ 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] Data transfer from two different sheets based on drop down menu using a button
    By rowlandjp in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-06-2013, 12:51 PM
  2. Replies: 0
    Last Post: 02-05-2013, 09:35 AM
  3. Drop Down Menu linked to COUNTIF Function
    By mygsprc in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-08-2010, 12:32 PM
  4. Drop Down menu & multiple linked cells
    By darken99 in forum Excel General
    Replies: 0
    Last Post: 06-05-2007, 01:03 PM
  5. Drop Down menu & linked cells
    By darken99 in forum Excel General
    Replies: 4
    Last Post: 05-30-2007, 03:44 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1