A moving auto population of cells based on date

[aevans7]

Hi,

I have learnt so much from this forum and have reached the point where I need to ask for some help! I am working on a workbook whereby the data needs to be stored each week in an archive sheet. Is there any way of doing this automatically? If this could be an action that is performed each time the workbook is opened that would be brill! The example shows (in a very basic form) what I would be after!

Thanks

Example	Today's date: 05/12/13
Date	Data 1	Data 2	Data 3
04/11/2013	1638	3533	247
11/11/2013	506	4654	4243
18/11/2013	485	4108	1614
25/11/2013	3503	4581	3630
02/12/2013	4152	2412	3414
09/12/2013
16/12/2013
23/12/2013
30/12/2013
06/01/2014

<COLGROUP><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width=105><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
</TBODY>

 

[oldbrewer]

why do you need to archive data? can you add all new data to your table in sheet 2 and pull from it (in sheet 1) only the last 2 weeks worth of data?

 

[aevans7]

I need the past data stored from each week to provide a look back comparrison. The data set is around 40 c by 3,5000 r, and I perform various countifs on the data. I then need to be able to refer back to previous data at a fixed point in time to demonstrate progress and throughput. It would be the result of these countifs that I would need pulled over on a weekly bases whilst still retaining the previous data.

Thanks

 

[oldbrewer]

So if you keep all your data on sheet 2 and analyse it on sheet one you are sorted.