insert blank row and formulas

S

scottmcm

when I insert a new row in my worksheet, I noticed it does not update the
formulas for any row below that line that reference another sheet in my
spreadsheet. For example, if my formula references 'sheet2'!I14 and I insert
a row above that formula it does not change the formula to 'sheet2'!I15. Is
there a way to have it where it does update the formula properly just like it
would do if I referenced a cell on the current sheet I was working on?
 
L

Luke M

Why would the formula need to change? You're moving the output destination,
not the input location.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
MS Project Import Error Row 1 Column 5 2
Insert Row also adds formulas and moves cursor 2
Working outlook via vba code with xlsx - error 0
Cumulative formula for word table 0
How Do I Avoid #REF! In Formulas? 5
Publisher adding blank page when printing my booklet... 2
Code to cut a paragraph that's followed by a table 2

Top