Reports

[Dave Eade]

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

 

[Bob Alhat]

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