big question

[dhx10000]

I have a workbook with one sheet that has about 14 columns worth of data. The company I work for basically wants to be able to run lots of different reports from this data that will display by week. So I am thinking I need to do three things:

1. Somehow capture the 14 columns worth of data on a weekly basis and store it somewhere
2. Create a master workbook that will contain all the macros that will allow them to run their reports from this master file.

First of all, am I going about this correctly? Secondly, if I am, how do you suggest I capture and store this data, weekly?

Thank you,

SR

 

[PaddyD]

Hi.

Really depends on what reports you need, but if everything is to be grouped by weeks, then I'd probablky start by adding the week number as a data element to the table (see help file for weeknum() ), then do the summary stuff in, eg, a pivot table...