Detectiveclem
Active Member
- Joined
- May 31, 2014
- Messages
- 320
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hi can anyone help with a formula which will allow the last date entered in a row to be captured in the last date entered cell (E.G. Cell A2) And the last Item entered to appear in the last item entered cell (EG Cell B2).
Please see the attached sample with the data shown in green for illustration purposes to show the data I want captured.
So for example at present A4 shows 10/01/2021 and B4 shows Application but if further dates or items are entered in G4 / H4 then A4 and B4 change to show the latest information.
I hope I have explained this sufficiently.
Your genius would be greatly appreciated.
Please see the attached sample with the data shown in green for illustration purposes to show the data I want captured.
So for example at present A4 shows 10/01/2021 and B4 shows Application but if further dates or items are entered in G4 / H4 then A4 and B4 change to show the latest information.
I hope I have explained this sufficiently.
Your genius would be greatly appreciated.