Figer la valeur d'une variable

hello
I talk to the experts to excel VBA programming.
I have a variable that represents the cash that I named "Cash", there are revenue and expenditure. The fund varies throughout the day quite sure. To display the value of the fund today, I used the following formula: = IF (date = TODAY (); Fund; "") see attached file.
But this formula shows me the value of the fund just today, I need a macro that shows me the value of the fund each day, that is to say, throughout the day I want to see the real value and variable of the case, the next day I want to see the value of the fund at the end of yesterday froze corresponding to yesterday's date.
The credit union continually varies throughout the day. I want to fix its value at the end of the day in the corresponding cell to the present.

Thank you for your help

Try next code: To be installed in the sheet code

Please Login or Register  to view this content.

Thanks very much for your help
the file caisse1.xlsm work perfectly for me.
But i tryed to use this code on my original file, i don't succed.
How can i use this code on my original file on all the yellow column : C-G-I-K-N-P-R-U-W-Y

thanks

Will you please confirm my understanding:
Columns concerned are : C-E-G-I-L-N-P-S-U-W
You want for each column to copy the value of cell in row 1 into the cell in the row corresponding to TODAY.
This must be done for each change in cell in row 1

yes column C (from C5 to C369) depend of changes of Cell C1
column E (from E5 to E369) depend of changes of Cell E1
column G (from G5 to G369) depend of changes of Cell G1

and so on, have a look on line 302.

i think it must be one macro per only column

Lets begin by column C

thanks

"i think it must be one macro per only column" ==> Hopefuly not
Take care about the columns used.
See next code
Be awared that the value at the "today" row is updated only if cell in row 1 has changed

Please Login or Register  to view this content.

See new macro

In the file attached, if you change cells "A1" value, the value in cell "E1" will change due to the formula and cell "E304" will be updated with "E1" value.
That's what happen on my PC.

See attached the last revision.
When the file is openning a macro is launched to check where in column A is to day date.
When it found the date it do a copy from Column B to C at the date row.
Now when there is a change in columns "C-E-G-I-L-N-P-S-U-W" at row 1, the value of these cells are copied to the same columns at row where to day was found.

Here another variation but it needs an extra row (here row1) to record previous values.
This row can be hidden