Currently I'm running a Query that stores all the information it gets out of it into a table called "Query" on the 'ValidationTool' page. I can edit the dates the query goes through, by editing cell C1 example (5/22/2015 or 5/29/2015). I have another table called "Rooster" that helps to analyses the data and is on the 'Department Rooster' page. Then I have a PivotTable called 'Analysis' which helps to summarize all the data from the "Rooster" table into neat information.
Yet what my main issues is I can't figure out how to use VBA to refresh the PivotTable every time I enter a new data and the new query results show up. Any help on this would be much appreciated.
Bookmarks