consolidate data and find the difference

[acroteau]

I pull a report from an database for work that contains fundraising data. Column A is "First Name", Column B is "Last Name" Column C is "Email" and Column D is "Total Amount to date".

I pull the report every week and each week there is added data for new entries and the total amount raised for previous entries is updated to current. I also save the report each week as its own file.

I want to be able to take the reports, combine them so that all the data is consolidated on 1 sheet and it shows the difference between week to week. I tried to set up a pivot table, but I cant get the pivot table to subtract "total amount to Date" from the newest Sheet form "Total amount to date" from the previous week.

 

[Fazza]

Welcome

For sure there is a date field in the database. So, just make a pivot table (or cross-tab) report straight from the database. (if using a pivot table, make the date field a column field and group by weeks.)

OK?

regards