To see how to schedule events using VBA, go to:
http://www.cpearson.com/excel/OnTime.aspx
You say:
Quote:
|
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.
|
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.