capture data on certain dates

[Peterw_2506]

Hi everybody,

I have a function that works but doesn't work, can anybody help me please.

I have a table that on certain dates I need to copy information into certain cells from other worksheets in my workbook. This formula =IF(B24=TODAY(),'Summary Sheet'!P33,"") works but when the date passes that is in cell B24 the information copied in is not retained. Does anybody know what I need to do so the data that is referenced in is retained. I'm trying to stay away from VB as I have zero experience and knowledge about it (something I'm going to have to address soon I think).

Be grateful for all help. Thank you in advance.

regards, Peter

 

[energman58]

Maybe use something like:

=IF(B24<=TODAY(),'Summary Sheet'!P33,"")

So long as B24 doesn't change this will always return P33 once the B24 date has passed

 

[Peterw_2506]

Thank you for your thoughts, cell P33 is constantly evolving so what I need to do is capture the data because in one weeks time (the next capture date) it will more than certainly have been modified

 

[energman58]

I think you need to think about a programatic solution then - you need to change your formula driven answer into something that will not change. it need not be too complicated - just record a simple copy and paste special macro. You can use OnTime to run your macro but you will need a way to determine when it should run - and, more importantly, when it should not but if you simply copy and paste the value back over the original formula it wont matter if the procedure kicks off again as it will simply copy and paste fixed value