if statement to collect data per day without overriding

I'd like to populate a sheet daily from the same single cell which contains a "countif" statement from another data source and changes data daily.

So i have a column of dates in A:A and blank data in B:B. On sheet2 in X1 is the data required. So the If statement would be in B1 .... =if(A:A = today() then add X1... But then when it comes to the next day my previous data will be false and wiped just adding the next day.

Is there a way of saying When it is today add this data and then save the data over the formula ? or is there an easier solution I'm missing here ?

I'm not quite clear what you require, would you please be able to upload a sample workbook with expected results? There should be instructions in the yellow box at the top of the page.

added example sheet

I'm still not really sure what you want it to do, but agree with Glenn that it sounds like you probably need a VBA solution.

Thanks i will post in VBA

What do you want the macro to do? Copy the data in C12:D12 on Sheet2 and paste to column B and C in Sheet1, for the row that corresponds to today's date? Where do you want to run it from, Sheet1 or Sheet2?