troubleshooting Question

How can I create a Print Array of worksheets from names in column of the sheet names?

Avatar of David Robinson
David RobinsonFlag for United States of America asked on
Microsoft ExcelVBA
3 Comments1 Solution28 ViewsLast Modified:

I am trying to write a print macro that creates a print array of worksheets from a list of the worksheet names and select only the sheets with a value in another column.  Example List of Sheet names are in A2:A100.  The selection criteria is in B2:B100.  

A1:Sallys Pay, A2: Mikes Pay, A3: Steve's Pay    B1:Full Time, B2:Part Time, B3:Full Time   I would like to select the Full Time and print as a single document.  

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros