i have created a formula that looks like
cell B2 = (A2+B1)
Cell B3 = (A3+B2)
and i have dragged this formula down.
How do i make it so if i insert a row the formula will be updated so the new row is included?
This can be done - if you copy the previous row and then do INSERT COPIED CELLS in the row where you want to insert. Just change the values in the other columns as required.
If this method does not suit you, you can go in for VBA.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Just drag the formula down from the row above. Excel should accomdate the cell address.
was hoping to do it without dragging down the cells when a new row is added, as i am setting up the spreadsheet for someone else who has limited knowledge of excel and is likley to change the formula's accidently
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks