Moveing Data on certain Days

[carluk]

Morning Everyone

Can anyone tell me if it is possible to move data form one column to another after a certain amount of days have elapsed.

I have attached a small excel file for an example that has data in column D that I would like to move to column C one week after column D has been modified.

Cheers

[Dav]

It is possible but painful to accomplish,

an alternative appraoch is to have all the data in a seperate sheet, with the weeks/dates it relates to and use a sum product or sum if to update the 3 columns show on the spreadsheet. this has the advantage that you can look at previous weeks if you need to

Regards

Dav

[carluk]

Cheers for the reply.

Is it possible then to look up the second from last entry from another sheet or is it as easy just to enter the new vs old valves manually

[Dav]

It depends how you enter the data. the following is an idea and i would hide the column with the dates in.

Does that help

Regards

Dav

[carluk]

thanks for that Dav

I can see where you are comming from I should be able to make that work

cheers