I have a sheet set up with a print area 1 page tall by 5 pages wide.
Is there a way to make certain pages from the print area print dependent on if a cell is blank or not?
For example: If Cell A of Sheet 1 is not blank, print Page 1 of Sheet 2. If Cell B of Sheet 2 is not blank, print Page 2 of Sheet 2, and so on. Additionally, Page 1 and 5 of Sheet 2 always need to be printed.
Is there a function or VB code that can be written to accomplish this?
Is there a way to make certain pages from the print area print dependent on if a cell is blank or not?
For example: If Cell A of Sheet 1 is not blank, print Page 1 of Sheet 2. If Cell B of Sheet 2 is not blank, print Page 2 of Sheet 2, and so on. Additionally, Page 1 and 5 of Sheet 2 always need to be printed.
Is there a function or VB code that can be written to accomplish this?
