Is it possible to automatically copy formulas from other rows to new
rows when adding a new line in a spreadsheet? I have cols A-AE of
which cols A-N are inputted and the others are calcualated values from
the data. How can I copy these formulas to the new cells when I add a
new row of data? Currently I have several 'dummy' rows that contain
the formulas that are used to input the data. Then I have to sort the
worksheet to get the new rows inserted properly. I'd like to insert a
new row at the proper location, enter the data and have the formulas
copied to the new row. Any ideas?