Printing pages

D

Dkso

I have a spreadsheet that pulls info into a report. This report is
usually only a few lines long and prints onto one page of paper
without any problem.

Sometimes however there is enough info to go over the page.
Currently I have formula on each line of the report page that gets the
info, if there is no info the line is left blank. Is there any way to
fill the report down three or four pages with these formula but only
print the one or two pages that have info or can anyone suggest
another way of doing it.

Page one

Report Header
....
...

Line of formula, pulled from page two if there is data to pull
Line of formula, pulled from page two if there is data to pull
Line of formula, pulled from page two if there is data to pull
Line of formula, pulled from page two if there is data to pull
..
..
..

Down to the full fourty lines of data for 1 page.
Sometimes I need forty five or sixty or seventy lines but this will
print blank pages if I fill the formula down.

Any ideas?


Regards Dean
[email protected] <mailto:[email protected]>
www.dkso.co.uk/ <http://www.dkso.co.uk/>
http://homepage.ntlworld.com/dkso
 
D

Dave Peterson

I think the easiest way is to apply Data|Filter|Autofilter to your range.

Then pick a nice column and show only the non-blank cells in that column.

Print the file

Data|filter|showalldata

to see everything once again.
 
Top