ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   IS there a way??? (https://www.excelbanter.com/excel-programming/405151-there-way.html)

Mekinnik

IS there a way???
 
I am trying to create a page that would generate a report using my existing
data, however when I try to do it in excel I cannot figure out how to make
the program recreate multible pages(reports) for my data. My report is only
able to show 15 rows of data with all the page formatting and the header
added. Once I get this working properly I will end up with about 200 plus
rows of data. So my question is, would it be eaiser to create the report page
in Word and then have it figure out how many pages(reports) would need to be
created or should I keep it in excel? Also if I keep it in excel how can I
accomplish this??

Nigel[_2_]

IS there a way???
 
Use page breaks in Excel to control the output. Set up page to have a Print
Titles, Headers and Footers.

--

Regards,
Nigel




"Mekinnik" wrote in message
...
I am trying to create a page that would generate a report using my existing
data, however when I try to do it in excel I cannot figure out how to make
the program recreate multible pages(reports) for my data. My report is
only
able to show 15 rows of data with all the page formatting and the header
added. Once I get this working properly I will end up with about 200 plus
rows of data. So my question is, would it be eaiser to create the report
page
in Word and then have it figure out how many pages(reports) would need to
be
created or should I keep it in excel? Also if I keep it in excel how can I
accomplish this??




All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com