I'm hoping someone can help me with a problem i'm having. Basically i have a table, at the top is a summary, within that, cell D6, all i want it to do is display a value, the value i want it to display is from a range of cells (D11:D49). D11 has a value in it (the rest are empty) and every week another value will be added below the last, D12, D13 etc. So all i need is for the cell D6 to display the latest entry (which is the cell lowest down) in the column of cells.
I thought this would be a simple thing to do but i cant work out how to do it. I have done some searches online but they come back with info about macros and the like which make no sense to me, i thought there would be a simple way to do this, please help!
Paul
Bookmarks