What formula can I write to enter a value in to the "Input Cell" (D4),
and: Successively update a cell in the Cell Range (A6:G6)
In the example below, the 9/4 entry updated to the 4.73. The next entry will update the 9/5 cell and leave all previous entries unchanged.
Thank-you very much.
Input Cell _4.73___
DATE: 9/1 9/2 9/3 9/4 9/5 9/6
PRICE: 4.14 4.53 4.68 4.73
and: Successively update a cell in the Cell Range (A6:G6)
In the example below, the 9/4 entry updated to the 4.73. The next entry will update the 9/5 cell and leave all previous entries unchanged.
Thank-you very much.
Input Cell _4.73___
DATE: 9/1 9/2 9/3 9/4 9/5 9/6
PRICE: 4.14 4.53 4.68 4.73
