Hello everyone:
In my project, I have a sales table (tblItemsSold) on Sheet("Sales Data") that is populated from cells on the Dashboard. I also have a date picker on the Dashboard so the user can select the period to filter the records in the sales table. The date fields link to date fields on the Sheet("Sales Data") and the filtered records are copied to a data range (Sales Data!Q8:AB). What I want to do is create a pivot table to use for a report showing the filtered records and then update the chart on the Dashboard with the totals for the selected period.
I am able to generate the pivot table I want if I convert the data range to a table however the destination range for the copied data does not update with the filtered records. I also tried creating a dynamic named range with the destination data range but was not able to get the desired results with a pivot table.
Am I approaching this all wrong? Am I even making any sense?
I am attaching some sample data. If anyone can help, I would be grateful. Thanks in advance.
Bookmarks