Barryj
05-05-2011, 09:16 AM
I was wondering if it is possible to print pages from a workbook based on the time in column C row 5, then row 6 of a each page in the worksheet.
I want to print pages so that they are in time order, from earliest to latest, if the cell has text, it is to skip that page, also if it is blank to skip that page, once it has cycled through these two rows of each page in the range then print the remaining pages in the range.
There are 90 pages in the workbook and each pages info starts on row 4 column C of each page.
I have included a sample of the how the data looks on each sheet.
The example would print out 1,3,4,2 being the time order followed by the page with text in row 5.
Thanks for any help.
I want to print pages so that they are in time order, from earliest to latest, if the cell has text, it is to skip that page, also if it is blank to skip that page, once it has cycled through these two rows of each page in the range then print the remaining pages in the range.
There are 90 pages in the workbook and each pages info starts on row 4 column C of each page.
I have included a sample of the how the data looks on each sheet.
The example would print out 1,3,4,2 being the time order followed by the page with text in row 5.
Thanks for any help.