Hi,
I have a column (B) in worksheet "Bank" that contains a sorted (meaning that the newest date is in the lowest cell) number of dates and to which new date are added continuously.
Now I want cell "I10" in sheet "Control" to show the newest date in column B from worksheet "Bank".
How do I do this?
The problem is that new dates are added continuously, making it hard to pick a specific cell. Furthermore, I can't sort the dates in another way. So, for example, sorting the dates so that the newest date is always above (and thereby in cell B2), is not possible.
Thanks!
Bookmarks