A moving auto population of cells based on date

aevans7

New Member
Joined
Dec 5, 2013
Messages
2
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

ExampleToday's date: 05/12/13
DateData 1Data 2Data 3
04/11/201316383533247
11/11/201350646544243
18/11/201348541081614
25/11/2013350345813630
02/12/2013415224123414
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>
 

Some videos you may like

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
Joined
Apr 11, 2010
Messages
11,003
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
Joined
Dec 5, 2013
Messages
2
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
Joined
Apr 11, 2010
Messages
11,003
So if you keep all your data on sheet 2 and analyse it on sheet one you are sorted.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,753
Messages
5,524,654
Members
409,597
Latest member
Dannydev

This Week's Hot Topics

Top