Excel Question...
Dear Lazyweb,
In Excel, is there a way to add a row to a worksheet that already has a predefined set of formulas in it? Or a way to have a predefined set of formulas automagically put themselves in all new rows? (Just copying them in afterward is not a good solution as I'm trying to make a sheet that even an idiot could add lines to without needing to know about copy formulas.)
Also, is there a way to communicate to Excel that I want a certain set of formulas added to each row that gets added to the bottom of the sheet as I scroll further and further down?
In Excel, is there a way to add a row to a worksheet that already has a predefined set of formulas in it? Or a way to have a predefined set of formulas automagically put themselves in all new rows? (Just copying them in afterward is not a good solution as I'm trying to make a sheet that even an idiot could add lines to without needing to know about copy formulas.)
Also, is there a way to communicate to Excel that I want a certain set of formulas added to each row that gets added to the bottom of the sheet as I scroll further and further down?