store data

[matt1978]

hello, i am trying to create a work sheet that does this: once a week
will put in an ammount of hours in cell B1. every time i put a ne
number in B1 i would like it to be recored in D1 then D2 then D3 et
how would i do thi

 

[Paul]

hello, i am trying to create a work sheet that does this: once a week i
will put in an ammount of hours in cell B1. every time i put a new
number in B1 i would like it to be recored in D1 then D2 then D3 etc
how would i do this

You would need a macro to accomplish this.
As an alternative, why not enter the data in the next available cell of
column D, and have a formula in B1 to return the last entry in column D?
=INDEX(D1100,MAX(ROW(D1100)*(D1100<>"")))
Array-entered (Ctrl+Shift+Enter rather than just Enter)