I have a cell that I want to always reflect the value of the last entry in another column. How can I get the cell to return the last number of the column, it is always being added to so will move further down as more data is added.
I have looked through the functions but can't find one that appears to give me what I am after. Would prefer to use a function and not a bit of VBA or a macro
I know of no function but assuming that the cell you wish the information to be in is A1 and that the column is B then the following small bit of code placed in the code of the worksheet itself will do the job
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Decided not to be beaten and went in again, Whisperer, your second answer works. The data is in column E (wonder how VoG knew that) so I changed the B to E, A1 now reflects the last figure in E but only if it coincides with the last entry in B. This is not an issue as the two will always finish with an entry at the same time.
Just as a learning exercise, what gives it the reference to B?
In the code below the A1 is the cell in which you are going to store the value of the last cell in the desired column.
After the = sign we are looking for the last cell that contains data in the correct column. In your case you have stated that it is column E (or 5) so I have amended the code to reflect this so you can compare with the original.