It often occurs that I write a function in one cell and then copy it into many cells. The copies then refer to their own correct rows. But if I change the function in the first cell the copies are unaffected. I have to replace all the copies with new ones. It is copy-paste programming when what I really want is to write a function in one place and call that function as though it were a copy from a bunch of subordinate cells.
Is there a technique to achieve this, or am I hoping for too much from the spreadsheet programming model?