Forum Discussion
Create query displaying sum and count and totals
I have a timesheet where every entry has a Category, and total number of hours spend on that task. It looks like this... How can i create a query/summary on another sheet in my excel doc...
One way to do this is a pivot table.
The downside here is when i add a new row entry on the timehseet, the summary does not update to include the new entry. This is the part im trying to really have automated as this initial page will grow and it will be annoying to have to go and update the summary page manually every time a new entry/row is added.
A pivot table doesn't update itself automatically. The dynamic array formulas in my second sample workbook do.
The attached sample workbook (now a .xlsm) shows how to use code to update the pivot table automatically when the Summary sheet is activated.