#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default Reports

Possibly yes,

Or use Excel Filters (Auto or Advanced)
or Excel Database functions; DSUM, DCOUNT, DAVERAGE, DPRODUCT etc
or use MSQuery to query your workbook from another
or Use Word Mail-merge to produce reports using 'Rules' (Word 2007) or 'Word
Fields' (Word <=2003)

Really depends on your reporting requirements, and how comfortable you are
with the technologies.

Bob

"Dave Eade" wrote in message
...
Hi,
I have quite a large spreadsheet 1000 rows by about 50 columns.
I want to have some "pre-defined" reports that I can print.

I was thinking of using a macro, but that seems tiresome - is an easier
option to transfer the data into access and then have define the reports
from
there?

Thanks


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report Prashanthi Setting up and Configuration of Excel 0 February 18th 08 03:02 PM
Bug Reports Daniel L. Lieberman Excel Discussion (Misc queries) 0 June 5th 07 01:52 PM
Help! Reports Muffin Excel Worksheet Functions 1 August 31st 06 03:51 PM
Looking for Way to Do Reports Drew Cutter New Users to Excel 4 April 25th 06 01:39 AM
reports herbzee Excel Discussion (Misc queries) 5 March 1st 05 10:25 PM


All times are GMT +1. The time now is 04:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"