Please see the attached sheet wherein would like to print certain page number if the cell contains a value
For. Eg.
In sheet1, D5 contains a number so it should print page 1 to 2 on sheet2
In Sheet2, D6 contains a number so it should print page 3 to 4 on sheet2
and so on
D9 does not contain a number or is 0 so nothing should be printed
D10 contains data so it should print page 6 to 8 on sheet2
When printing it should also ask for a selection of printer only once at the start and not for each page to what it needs to print