+ Reply to Thread
Results 1 to 3 of 3

Multiple criteria selection to open a sheet

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    Toronto, ON
    MS-Off Ver
    MS Office 2010
    Posts
    55

    Multiple criteria selection to open a sheet

    Hi everyone. I am looking for a code that will look at the values in 4 different cells to determine what (hidden) sheet in the workbook to display as a pdf to print. Users will select from 4 different drop down lists of choices; the combination of these choices will equal a form (the hidden sheet) for the user to print via a command button where the code will reside. The cells where the drop down choices will be entered are D12, F12, H12 and J12 and there could be up to 20 different combinations. I am looking at something like "if D12 = "Choice1" and F12 = "Choice A" and H12 = "Item1" and J12 = "ItemA" then printtopdf Sheet1 (where the print area will be defined)". So Sheet1 meets the criteria of Choice1, ChoiceA, Item1 AND ItemA. Sheet2 will equal another combination.

    Any ideas?

    Thank you for your help

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Multiple criteria selection to open a sheet

    I'd check which character is not present in any of the criteria and then used concatenation of selected strings separated with such sign
    for instance you probably do not have hash signs in your option names, so:
    Please Login or Register  to view this content.
    and then you could use simple VLOOKUP ora any other method to select from table:
    HTML Code: 
    etc.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    07-21-2014
    Location
    Toronto, ON
    MS-Off Ver
    MS Office 2010
    Posts
    55

    Re: Multiple criteria selection to open a sheet

    Thank you for your replies. I am trying to mark this as "solved" but can't seem to locate where to do this...

+ 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: 5
    Last Post: 01-07-2015, 07:17 AM
  2. [SOLVED] Automatically open a different sheet within the workbook when a selection is made
    By clovelly in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-16-2012, 10:53 PM
  3. Multiple selection criteria, which formula? .. and selection based on unique numbers
    By FalkirkJim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2012, 05:22 PM
  4. Displaying columns in a sheet based on the selection criteria in another sheet.
    By gangavs11 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-06-2012, 08:33 AM
  5. Multiple Criteria function selection from another sheet
    By Mandii in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-12-2010, 07:47 PM

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