Originally Posted by frost240z

OK so I have been racking my brain for weeks trying to figure out how to extract totals from a daily report. Basically I have a sheet that I refresh daily to bring in the data from a text file. In that data is a Source Name field, a Exit Date field, and a Quantity field. Without messing up the data sheet (because it changes daily and I have to keep refreshing it) I need to have the monthly total calculated. I want to be able to have someone else that knows nothing about excel to be able to just open, refresh, and send. I have been messing around with DSUM() and Pivot Table then using GETPIVOTDATA() functions with little success. I put something together using DSUM() but it is clunky and isn't very dynamic when it comes to adding sources. If I could some how put an variable inside my GETPIVOTDATA() function that would only total quantities under a particular source name where exit date is between 02/01/11 and 03/01/11. I am using Excel 2003 and here is what the data looks like. Thanks for your help.
I want it to populate a grid that looks like this:
Analysis
Total Earlier Feb-11 Mar-11 Apr-11 May-11 Jun-11
Source 1
Source 2
Source 3
Source 4
Source 5