How do I Insert rows in excel while maintaining formulas from previous rows? Is there a way to Insert but copy previous row's formulas?
Posted on 2007-10-02
We're using Excel 2003 and I have a simple budget sheet.
When my users enter their numbers, they sometimes insert their own rows (even though there are hundreds of rows available).
When this happens, the formulas get messed up. Is there an easy way to have the previous row copied when a row is inserted?
If possible, no VBA answers as I don't know VBA (unless you can provide the code - which would be greatly appreciated)
Thank you for any information you can provide. I have a budget meeting in 3 hours - Please help!