Reports
 

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

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