The attached sample excel has three sheets:
Sheet “data” - This sheet has the raw dump of data
Sheet “pivot” - This sheet has a pivot build out of the “data” sheet
Sheet “stats” - This sheet builds a summary data using the “pivot” sheet
The goal is to refresh the pivot table in the “pivot” sheet once new data is added in the “data” sheet.
Any help would be greatly appreciated.
sample_pivot.xlsx (15.4 KB)