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