+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Macro to select filtered results from a different sheet in a workbook!

  1. #1
    Registered User
    Join Date
    08-04-2010
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Macro to select filtered results from a different sheet in a workbook!

    Hi all,

    I am having great difficulty putting together a system on excel.

    The aim of the system is to allow a user to pick their choice out of a selection of 9 criteria. Each of the 9 criteria has a dropdown list of available values. The idea would be to allow them to pick between 1-9 choices out of the drop down boxs, therefore meaning any working macro would have to be able to ignore blank selections.

    http://img695.imageshack.us/img695/3317/pic1no.jpg

    The next stage would be for the macro to filter (or look through) a list on a second sheet in the workbook, find all the results that match all of the criteria given (again ignoring the criterias that are left blank), and paste all the applicable results on the front page, hence never showing the user the backpage.

    http://img185.imageshack.us/img185/2963/pic2fc.jpg


    I am hoping this is possible, but if anyone knows of a simpler way to do this (whilst hiding the data source, does not have to be secure, just out of sight), then i would appriciate the suggestion!

    I'm attaching a mock spreadsheet for anyone willing too have a look. The data is false but the headings and cell locations are all correct.

    Thanks alot,

    Michael
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-04-2010
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Macro to select filtered results from a different sheet in a workbook!

    Anybody have any suggestions? Completely stuck on this lol

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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