Display last entry from Column on worksheet on a dashboard

[MOONDRIFT47]

Hi,

I am trying to get the last entry on the sheet S1 in the attached workbook to display in cell B3 in worksheet Status. I didn't think thee was a formula that would copy the last entry each time.

[torachan]

see if this does what you want - it checks for the last row of data in each sheet and records what is in column 'B' - it is a small macro on yellow button.

[MOONDRIFT47]

Thats what I was looking for. Is there a way to display the date for each entry by the side of the relevant reference for instance

Date S1 Date S2
27/11/23 Empty 25/11/23 Empty

As each last entry on those sheets would have a different date. Sorry, I just thought of that situation.

Thank you.

[torachan]

try the attached

[torachan]

thanks for the update and added rep point - glad it helped.

[MOONDRIFT47]

That's it, brilliant work. Many thanks