Copy last values in column before error dynamically

[RioDegenero]

I will appreciate help with VBA code to dynamically locate and copy the last values in column E before the errors and corresponding date in column A. This is the amount highlighted in yellow i.e. cell E16 and in column A also highlighted in yellow i.e. cell A16 from tab named Q1 in Excel file with filename "Input" to another Excel file named "Output" tab named "Summary". The values should be copied to cells C3 and C5 in the Summary tab of "Output" file. Here's the path to the file: C:\Users\Maindesk\Desktop\Consumer\Statement

Copied from image below:

Copied to image below

Thanks

 

[Fluff]

Duplicate to: Value before error in cell and corresponding cells

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.