You could create a custom view for each of the report layouts that you need.
It will be some work but if you're unfamiliar with Access this wouldn't be
overwhelming.

Look up Custom Views in help for details concerning the creation of a custom
view.
--
Kevin Backmann


"LoriH" wrote:

Each month I have three seperate Excel spreadsheets each with about 6000 rows
and multiple collumns. I need to breakdown and distribute different portions
of the data to various people. These seperate reports need to subtotaled and
formated to print but are sent via email.
There is a collumn in the spreadsheet that I use to decide who gets each
report. Depending on what is noted in the collumn, I email the report to
different people.
The number of different reports is growing and I now have to create about 70
reports from each spreadsheet. I need an easy way to break each of these
spreadsheets down. I am currently creating the seperate spreadsheets and
using a macro to subtotal, format to print and save the file.
Is there an easier way using access or VBA. I am not very familiar with
either Acess or VBA but and a quick learner and am willing to get training on
whatever will make this easier.