Carring over data from one sheet to another

[spectraflame]

I have a column that can have 1 - 24 entries. These entries are not taken every hour and are not necessarily taken at the same hour each day. To reduce data entry. The first day of the month is keyed in manually. The remaining days, on separate sheets in the same workbook, have manual data also, but a great deal is carried over from the previous day. If the previous days data was in the same spot every time, this would not be an issue, but they sometime end in cell A12, but some end in A9 or A4. Is there a way to have the value of the last entry in that column carried over to the next sheet?

So if my last entry on the 26th of JAN was 30% at 9:00 PM, my carried forward rate would be 30% for the beginning of the 27th of JAN.

Any suggestions?

 

[spectraflame]

Thank you for the explanation. I understand now. I think it will work just fine the way it is.

Thanks!
Matthew

 

[Jaafar Tribak]

Hi Aladin ,
Your approach is great.It has never occurred to me to use the Look up Function this way ! I like it very much.

I am really glad to have joined this board.There is so much you can learn here D)

Thanks.
Jaafar.

 

[Jaafar Tribak]

Hi Aladin ,
Your approach is great.It has never occurred to me to use the Look up Function this way ! I like it very much.

I am really glad to have joined this board.There is so much you can learn here D)

Thanks.
Jaafar.

 

[Jaafar Tribak]

Hi Aladin ,
Your approach is great.It has never occurred to me to use the Look up Function this way ! I like it very much.

I am really glad to have joined this board.There is so much you can learn here D)

Thanks.
Jaafar.