Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2008

Tip: Looking for answers? Try searching our database.

IS there a way???

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mekinnik - 28 Jan 2008 17:41 GMT
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 - 28 Jan 2008 17:46 GMT
Use page breaks in Excel to control the output.  Set up page to have a Print
Titles, Headers and Footers.

Signature

Regards,
Nigel
nigelnospam@9sw.co.uk

>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
[quoted text clipped - 8 lines]
> created or should I keep it in excel? Also if I keep it in excel how can I
> accomplish this??
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.