I need to make a sum function always equal the corresponding cell

T

tarabull

in cell a1 of sheet 1, i have an addition formula that contains
"=+AU1+BB1+'sheet2'!a1" if i insert a line above a1 on sheet 1 and it becomes
a2, the formula automatically changes to "=+AU2+BB2+'sheet2'!a1", how can I
get it to automatically change to "=+AU2+BB2+'sheet2'!a2"?
 
N

Norm

I don't know the specifics of what you're doing so the following may not
solve your problem but you can get the result you're seeking by selecting
both sheets before inserting a line. For example, with Sheet1 selected,
hold down the CTRL key and click on the Sheet2 tab. Both Sheet1 and Sheet2
are now highlighted and anything you do on Sheet1 will also be performed on
Sheet2. So inserting a line in Sheet1 will do the same in Sheet2... and
your formula will increment to the correct cell reference.
 

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

SUM of a 3D calculation 6
Countif contains a word in a reference cell 3
Cell highlighting question 4
use cell text in lookup function 3
CELL CONTENTS WRITE TO TAB NAME 0
Referring to a cell by using another cell for the row number 6
Dragging Cell References/Formulas 5
Cell Reference 1

Top