Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing one or more pages?
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. A VBA program would be acceptable if possible? Any ideas? Regards Dean www.dkso.co.uk/ <http://www.dkso.co.uk/ http://homepage.ntlworld.com/dkso |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
printing on many pages | Excel Discussion (Misc queries) | |||
How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
Printing 3 out of 4 pages | Excel Discussion (Misc queries) | |||
PRINTING PAGES | Setting up and Configuration of Excel |