Conditional printing macro

[mcwilson]

Good morning all-

Question: I have a calendar tool within my sheet that displays the 12 months. I want to give the user options on what they can print.
In F:16-17 I have a list function that allows them to choose the starting month of what is to be printed.
In F:20-21 I have a list function that allows them to choose either 1, 2, or 3.
If January and 2 are chosen, I want to print January and February. If April and 3 are chose I want to print April-June, etc.
Any ideas?
Preferably they could just click on a picture to run this macro.

Too confusing????

 

[Trevor G]

Question have you got individual sheets for each month of the year or using Named Ranges? and are you wanting to use the values based on the cells after selecting from your list in cell F16 & F17.

Would be useful to see a sample of the is area in your sheet. That may help with a quick solution.