I have a solution that writes/appends data to a file every day. The end user wants a summary, essentially a pivot table, of the data in a second worksheet in the output file. Is there a way that I can append the daily data, and then have all of the data (current, and that already existing in the file) summarized dynamically and output to a second worksheet, maybe using Run Command? Data is a list of accounts, summary is count of accounts, grouped by account owner, so totals change daily. Thank you!
