Hello everybody,

I need help with the next problem;

Sheet 1 of a workbook has the next value in cells:
1. Cell B1 is the first of the month and C1 the 2nd, and so on until
the last of the month.
2. And A2 is "Line 1", A3 "left", A4 "right", A5 "bottom" and this will
repeat again in A6 "Line2", A7 "left" and so on until the data from line 6
and then the same but a total value of the 6 lines. The value for the
correspond ending data are filled in by handmade, started by B3 for Line 1
left and so on.

Now the problem:

Sheet 2 has in cell B1 as formula "=TODAY()" and in cell C1 "Line 1".
Cell B4 is text "left", B5 is "right", B6 is "bottom".

How can I see in C4, C5 and C6 the values from the day and line that I
change, by hand, in B1 and C1. So I put in Sheet 2 B1 "=TODAY()-1" and in C1
"line 4" I will see the value from line 4 from yesterday in C4, C5 and C6.

Please can some one help me? I'm from Belgium so if my English is not 100%
forgive me.