I have several SQL connected reports that have changing/disappearing data that I need to capture as a rolling snapshot before the data changes and disappears.



For example, I have a report that spits out PO lines that have not been released but once they are released they are no longer SQL accessible and they disappear. I know I could write another report to try to collect this based on some sort of date key but it is just not very reliable.

I want to capture the sum and count of incidents associated related to the buyer name at the end of each week in a new spreadsheet. Then the next week it does the same in a new column. I can then chart trends based on the historical data. Any easy way to do this? I am pretty good in SQL but not so much in VB and I am guessing this is the direction I will need to head. Also not interested in third party software.

Also, this data is on Sharepoint which I am just learning. There may be something with revision history based on last refresh?

To see how to schedule events using VBA, go to: http://www.cpearson.com/excel/OnTime.aspx

You say:
Do you want a new workbook, new sheet in an existing workbook, or a new column in an existing worksheet? Is there more than one buyer per week? Is there a reason all buyer data can't be output to different (or even the same) worksheets in a common workbook? Either way, you're going to have to construct your own query to extract the data in a format that you can use to (a) populate the workbook(s) and (b) analyse.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]