Macro to create a pivot table or data summary

I need a macro to create a pivot table or any other method that will summarize the data.
The workbook is attached.

1. Sheet "Filtered_Data" is the data that needs to be summarized.
2. The example of the final output needed is on sheet "Report".
     Summarize by: Columns - Date Delivered, Origin Zip, Recipient Zip, State, City, Address, Zone
                                 Data - Rated Weight, Ground Rate
3. The summary should include ONLY the rows where the rated weight is >=150 in the summary.
MWT-TOOL-v4.xlsm
Euro5Asked:
Who is Participating?
 
gowflowCommented:
Is that what you want ?

BTW your calculations in sheet Report of the grand total are not correct.
gowflow
MWT-TOOL-v5.xlsm
0
 
gowflowCommented:
If my understanding correct you want a macro that will generate a pivot same as the summary result in sheet Report ?
gowflow
0
 
gowflowCommented:
is this what you want ? check sheet3.
gowflow
MWT-TOOL-v4.xlsm
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
Euro5Author Commented:
gowflow,
I think we are close, thanks, but there should only be rows where the rated weight >= 150.
It also has duplicates of everything, but I'm not sure why.

Can you continue to help?
0
 
gowflowCommented:
ok I got rid of duplicates and all this now when it comes to rated weight >= 150 are we talking about the cumulative in the pivot table or the items in the Filtered_data sheet.

If in Filtered_Data we can create a extra column to show only items >=150 but I am afraid you don't have any. So I presume it is the total in Pivot that you want to filter is that correct ?

gowflow
0
 
Euro5Author Commented:
If in Filtered_Data we can create a extra column to show only items >=150 but I am afraid you don't have any. So I presume it is the total in Pivot that you want to filter is that correct ?

I need only the >=150 summary total.
0
 
Euro5Author Commented:
This is very close! I don't need Rated Weight or Ground rates in the columns, just the data.
When I remove them, I get exactly what I needed.
I don't see the VBA code though....
0
 
Euro5Author Commented:
Thanks!
0
 
gowflowCommented:
It was created manually and quite difficult as it is. I know you requested VBA but we can handle this in a separate question if this is what you want. Let me know.
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.