04-04-2020, 09:45 AM
|
|
Expert
|
|
Join Date: May 2013
Location: USA
Posts: 700
|
|
General rule of thumb: Excel worksheet functions never write data to other cells. They can look at other cells and use those values to help calculate the result they display; but they display only one value, and it's always in the cell where the formula is. So if you want your worksheet to see a new value in row 9 (or wherever) and respond by inserting new values in other cells, it'll have to be done in VBA.
And yes, it's possible in VBA. I mean, I'm sure it's possible, because almost anything is. I shouldn't be too sure, until I understand better what it is you want to do. But I'm not really doubtful .
Now, what you can do is put a formula in the cells where you want the new information. For example, in E2 you can put "=A9". I know that can't be what you really want, though—it's too simple.
|