I'm trying to see if there's a way to copy data from a cell based on the most recent timestamp in the A column.

Column A is where the time stamps are stored, and column B is the first information that would need to be copied in the separate sheet (Sheet2).

For example, there are already two time stamps in Column A:

6/10/2022 12:03:22 (A:2)

6/10/2022 12:34:01 (A:3)

Cell A:3 would be the most recent, therefore in a cell in the other spreadsheet (Sheet2) - it would identify that and return the value that is in B3, right next to the most recent date (A:3)

Here's the form:

References