Auto add last entered data in same row

[Detectiveclem]

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.

 

[billszysz]

Hi billszysz, I didn't try your formula as Fluff's suggestion worked fine and I don't wont to mess it up again. But thank you for helping.

No problem, thanks for the feedback.

 

[Fluff]

I would use billszysz' formula as it's a lot simpler than my effort.

 

[Detectiveclem]

Hi billszysz, I didn't try your formula as Fluff's suggestion worked fine and I don't wont to mess it up again. But thank you for helping.

Hi billszysz, Fluff suggest that I use your formula rather than his, which I have now done. It also works perfectly so thank you so much....You are both brilliant. Have a lovely weekend and thank you again.

 

[Fluff]

Glad we could help & thanks for the feedback.