"forumula" sounds kind of baleful, like something from a gothic horror.

I don't think that there's any way to automatically add data to a cell without resorting to macros.

In similar situations, I tend to select the cell, copy it, select the entire row or column (by clicking on its header), and then pasting. If you want to be tidy, you can wrap the existing formula: