What I want to do is have one worksheet that follows my bank balance, and another that has a data table that automatically updates everyday (column A of data table is date; column B of data table is amount for that day). I already have the first worksheet done as that is a simple =sum(A:A) to tell me the total amount of all the monetary values that I enter. However I do require assistance getting the Data table (that I will turn into a line graph) to automatically capture the value at noon everyday and place it into the correct position on the data table.

Help would be greatly appreciated