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
|