Excel- Print certain worksheets depending on value of a cell

May 31, 2016 at 13:07:14
Specs: Macintosh
I'm looking to print a variety of different worksheets depending on the values found in a column of cells (DE5:DE36). The values are relevant to a specific worksheet and there is a possibility to have 3 different values to one worksheet.

Any help would be greatly appreciated. TIA.


See More: Excel- Print certain worksheets depending on value of a cell

Report •


#1
May 31, 2016 at 13:15:05
A macro could certainly do what you want, but we would need more details.

Please keep in mind that we can't see your workbook from where we are sitting, so
you'll need to be more specific than "The values are relevant to a specific worksheet and there is a possibility to have 3 different values to one worksheet."

For example, we need information on how the values are "relevant" to a worksheet.
What does "3 different values to one worksheet" mean?
How will the code know which worksheets to print?
etc.

The more details you provide related to your process, the better the chance that we can offer some assistance.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question