I am using Excel 2007. I have an Excel file that has cell A1 showing a date and cell B1 showing an amount in sheet 1. I need to automatically update the date in A1 and amount B1 in a database in sheet 2. The database in sheet 2 is link to cell A1 and B1 in sheet 1 by using Vlookup by choosing the date in A1 as the lookup value. The excel file is use on a daily basis and cell A1 and B1 content will change daily. Sheet 2 will need to record all the dates and amount in cell A1 and B1 for one year
My problem :
1. How do i build my database to capture the previous date and amount in A1 and B1 daily because the dates in A1 keep changing as it is key in on a daily basis.
For example :-
On 14/3/2015 (cell A1) figure is $3,333 in cell B1. Hence the data base captures the date 14/3/2015 and $3,333 in sheet 2 in the database.
On the following day,15/3/2015, cell A1 content is now changed to 15/3/2015 and B1 shows a figure of $5,555
My challenge is how do I keep both dates and value in sheet 2 in my database since I can only get one date and value for the current day only.
Honestly I dont know VBA.
No comments:
Post a Comment