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.