I just couldn't find anything similar in the search so I thought I would try here. It's fairly straightforward though but I have little experience with formulas so please explain thoroughly. Here is my example:

A B C D E F G H
1 10.34 15.27 78.00 64.00


So what I am trying to do is track prices over time. I input the price each day and what I would like to happen is to have A1 show the latest price which in this case is E1 but will change every day as I enter numbers moving to the right. Being terrible at formulas I was just thinking maybe I could use zeros in the blank spaces F, G, H and so on and then right a formula whereby if the cell has a number and there is a zero in the cell to the right, then post that number in A1.

Hope you undersand what I am trying to do. Simple but confusing for me. Many thanks in advance.