Autofill that adjusts based on date entry

[kevinjay1]

Hello, I am not sure if this is a VBA question or an IF formula. I have a basic spreadsheet attached to show what I am asking for clarity.

On sheet 1, I have dates in column A, then numbers under LabA through C. On sheet 2, I would like the contents of columns B, C, D to autofill when entered. However, I would like to display only the last entry. For example, Lab A (column B) is currently showing "7" in cell B6, if I enter a number in B7, I would like for sheet 2 to autoupdate cell B3 and display that new entry instead of the "7".

Is this an IF formula or a similar one? Or does it need programming to accomplish this? I would like to try and avoid VBA for this if possible.

Thank you


backlog example.xlsx

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.