Help with a kind of complicated printing problem

Hi all,

I have about 240 pages to print. Each objective is a page (front and back). Column A and Rows 4:7 repeat. I would love to define where the printing range for each objective begins by the first non zero Ending Market Value in that objective (columns C,F,I,...).

For example, on the attachment, objective 1 would print the entire table, b8:d71. Objective 2 would print e22:d71. I greatly appreciate any help.

Thanks in advance,

Brad

Complicated Printing.xlsx

page layout->print title>-sheet->then select rows and coloumns

Thanks, Mohamed. I understand that part. Since the start of the print range for every objective will be variable, I am hoping to automate and get excel to determine where to start printing depending on the 1st non-zero number in each Ending Market value column.

Regards,

Brad