+ Reply to Thread
Results 1 to 5 of 5

Print array of sheets based on True/False values

  1. #1
    Forum Contributor
    Join Date
    09-12-2015
    Location
    Okinawa, Japan
    MS-Off Ver
    2013
    Posts
    170

    Print array of sheets based on True/False values

    I would like to print an array of sheets based on True/False values. I have attached a worksheet to help with the explanation.

    On Sheet("Dashboard") H3:H12 are True/False values. I want to print the associated Sheets based on these values. ie: H3=True, print Sheet("Andy"), H4=TRUE, print Sheet("Bob"), H5=FALSE, no print, etc.

    I also need to filter the printed Sheets so that if Column A has a value of '0', then filter out that row. For example, Sheet("Andy") has data in A8:A9, but '0' starting in A10:A58, data again shows up again A67, etc.

    Your help is appreciated.

    Ken
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Print array of sheets based on True/False values

    I didn't test it because I didn't want to waste my ink. Should work in theory though. Read in code comments before running:

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.

  3. #3
    Forum Contributor
    Join Date
    09-12-2015
    Location
    Okinawa, Japan
    MS-Off Ver
    2013
    Posts
    170

    Re: Print array of sheets based on True/False values

    stnkynts,

    This works great. Is there a way to have it take you to the excel print tab so you can have print options before printing? For example, select another printer, duplex or single-sided, etc. I guess I'm looking for the icing on the cake.

    Thank you in advance,
    Ken

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Print array of sheets based on True/False values

    Like this?

    Please Login or Register  to view this content.
    Or did you mean like this?

    Please Login or Register  to view this content.
    Note: The above 2 options are not going to work seamlessly like you think. You might have to identify the sheet to print each time. Here is a third option

    Please Login or Register  to view this content.
    Last edited by stnkynts; 09-27-2015 at 09:42 AM.

  5. #5
    Forum Contributor
    Join Date
    09-12-2015
    Location
    Okinawa, Japan
    MS-Off Ver
    2013
    Posts
    170

    Re: Print array of sheets based on True/False values

    Thank you for the other options...based on my testing, I think I will go with your first submission. I appreciate you working with me. Very knowledgeable.

+ 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: 7
    Last Post: 04-06-2014, 11:34 AM
  2. If array Formula (different True and False within a If function.
    By mortphil in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-14-2013, 10:05 AM
  3. print sheets BY array values
    By petix in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-29-2013, 06:51 AM
  4. [SOLVED] VBA code to hide/unhide sheets based on a tick-box (TRUE/FALSE)
    By kavindra in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-10-2013, 08:11 AM
  5. Return subsequent list based on true/false array
    By john. in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2012, 02:23 PM
  6. [SOLVED] Excel 2007 : Determining TRUE or FALSE based on multiple values
    By BarnesB in forum Excel General
    Replies: 5
    Last Post: 05-30-2012, 04:46 PM
  7. Sum values based on TRUE/FALSE property on different sheet?
    By grantpanderson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-19-2010, 11:38 AM

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