When I copy/paste cells, the formulas in the cells are updated, but they're usually off by 1 or more cells. Sorry if I am not explaining this very well. I'll try to explain using the attachment.
I copy the block of cells beginning at: X180 - AD180 and then down to X217 - AD217. I then try to make a copy of the copied block of cells to X232 - AD232. This works out OK, except when I look at the formulas, they are usually 1 or more rows off, i.e. the formula in AA232 reads "=AA178-AA229" and it should read "AA180-AA229", which puts the whole batch of cells 2 rolls off. I've tried various methods of copying/moving the data, with the same results. What I end up doing is going through the whole batch and manually correcting the formulas. What am I doing wrong and what can I do to correct it? OR is there an easier method that I can use to correct the formulas, instead of manually changing each cell's formula?
I hope I explained this correctly, if not I apologize for my ignorance. Thanks for any help.
Bookmarks