Hello. I have 50 rows of formulas that reference rows below them. I would like to add 51 rows to ALL of the references in these formulas. For example, in one cell, I have = sum(A12:A14) and I would like to make this =sum(A63:A65) but I don't want to manually do this for each cell. Is there an easy way to do this? Dankeshun.
Since there are no $ signs in that formula you can copy them another row and the references will adjust accordingly. So, one way is to:
1) COPY (Ctrl-C) the cells with the formulas you wish to "update"
2) Paste them into the row 51 rows down from where they are currently.
3) Highlight and CUT (Ctrl-X) the cells in the pasted section
4) Paste them back into the original positions above. The CUT command will preserve the adjustments from when it simply copied below.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks