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
Bookmarks