Everyday, I have to open the same file and input that amount and print it as a proof... I would like to know if there is a way to automatically input the amount for me, so I just need to print...

Here is what I want:

1. File_01.xls >>> File I open, input the amount, then print.
2. 06-Sep-2013 Client File.xls >>> File that show what amount to input in the File_01.xls.

Input Date Transit Client Accnt Amount Comments
06-Sep-13 $295.00 Stocks Purchased

As you can see, the Input and the Filename (06-Sep-2013 Client File.xls) as the same date. So I want to add a function to load the amount from a file that has the same Input Date.

i.e.
In my folder, I will have all file with a date:
06-Sep-2013 Client File.xls ($295)
09-Sep-2013 Client File.xls ($300)
10-Sep-2013 Client File.xls ($325)

If the Input Date in the File_01.xls is 09-Sep-2013, then the amount should be 300$ (NOT $295 nor $325).

Is there any formulas that can do this or it has to be a macro?

Really appreciated if anyone can help.

Thanks.File_01.xls06-Sep-2013 Client File.xls