Excel 2010 Report Creation

I have a report called Open Incident Agining.  This report gets run every month and then sent to the associated manager of the assignment group.  What I have been trying to do, unsuccessfully is automate the report generation for each Assignment group manager.  What the report should look like is filtered by the Assignment group manager(field is column K),  then by Assigned To (column L) broken out by aging category (column c) and then list all of the outstanding tickets (column a) within each aging category.  

My desired state would be to have a script that can be run on the imported report every month and separate files created for each Assignment Manager.  That way each file can be emailed to the assignment group manager directly.  

Any help or direction would be greatly appreciated.   I have attached the spreadsheet of the raw data.
Open-Incdent-Aging-Report.xls
Rrave26Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
I would use Advanced Filter to create the reports. This can be automated with VBA

I've used this method in the past successfully, I can help you with the code but not until later.
Rrave26Author Commented:
That would be great if you could help with that.  I have limited experience with VBA code and it would take me some time to figure this out.
Roy CoxGroup Finance ManagerCommented:
If I get chance tgis evening I/ll have a look, if not I'm free tomorrow afternoon
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

Rob HensonFinance AnalystCommented:
You might also be able to use Pivot Table to create separate reports.

Thanks
Rob H
Roy CoxGroup Finance ManagerCommented:
The code that I have added will generate a report based on the selected criteria.

Which version of Excel are you using?

The code can be automated to email the report, but you need the email addresses adding.
Open-Incdent-Aging-Report.xls
Rrave26Author Commented:
I am using Excel 2013.  I have opened the code and found that you need three criteria to select the report.  I really only need two.  The Name, which in this case is the assignment group, and I need to be able to select a couple of agining categories, i.e., I need to select 31-60, 61-120 and greater than 120.
Roy CoxGroup Finance ManagerCommented:
You can add Criteria simply by listing them below the previous one and changing the criteri range. Read up on AdvancedFilter and you will see what I mean. See if this does what you want
Open-Incdent-Aging-Report.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Rrave26Author Commented:
My apologies,  I lost sight of this with other work priorities.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.