formula or vba

[Matt Rogers]

Hi @ll.

Tomorrow the value should be automatically from B2 to A3
But I do not know how.
Thanks for help.

Excel Workbook
	A	B	C
1	Yesterday	Today	Difference
2	100	80	-20
3
Sheet

 

[jbeaucaire]

In A3, then copied downward:

=IF(B2="", "", B2)


if you don't want to copy down, just put that formula in A3. Then go to TOOLS > OPTIONS > EDIT: [x] extend data range formats and formulas.

 

[Peter_SSs]

Maybe this slight change to Jerry's suggestion so that nothing shows up in the next row until the 'Today' value is entered (like you have set up in column C).
For A3, copied down
=IF(B3="","",B2)

Also, I don't know just what your full requirements are, but this may suffice in C2 (copied down)
=IF(B2="","",B2-A2)

 

[Matt Rogers]

Hello jbeaucaire & Peter.

Please excuse my silly question.

=IF(B3="","",B2)
and
=IF(B2="","",B2-A2)

=exactly what I'm looking.

Very many thanks and greetings.

 

[Peter_SSs]

Please excuse my silly question.

No need to ask to be excused - the forum is here for people to ask whatever questions they have.
BTW, a belated "Welcome to the MrExcel board!"