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.