Thread: Reports
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Alhat Bob Alhat is offline
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