# A moving auto population of cells based on date

#### aevans7

##### New Member
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>

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### oldbrewer

##### Board Regular
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

##### New Member
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

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

Replies
1
Views
125
Replies
3
Views
268
Replies
1
Views
175
Replies
6
Views
469
Replies
3
Views
215