I have a report that I am updating manually and I am wondering if there is a way to update the report more efficiently (pivot table, vba...). Using the pie chart in the report I identify the top 6 by percentage. Once I have the top 6 I then have to identify the top 3 stores with the longest delay. I am currently using pivot tables to capture the data to be updated manually it is a little time consuming and leaves a lot of room for human error. I am attaching a generic copy of the report, Any help would be appreciated.