I am updating a list of closing prices each day. I would like to write a formula that posts the value entered in cell B2 to the next empty cell in the range C4-C10. Each prior day entry must be maintained in the list. I would appreciate any advice on how to write the Formula.
The range of...