Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to make a sum function always equal the corresponding cell
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"? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to make a sum function always equal the corresponding cell
Possibly
=AU1+BB1+INDEX(Sheet2!A:A,(ROW(A1))) Mike "tarabull" wrote: 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"? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to make a sum function always equal the corresponding cell
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. "tarabull" wrote in message ... 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"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
make cell length always equal 10 | Excel Discussion (Misc queries) | |||
make a cell equal a worksheet name | Excel Discussion (Misc queries) | |||
can I make worksheet name equal a cell | Excel Worksheet Functions | |||
How do I make one cell equal to another | Excel Worksheet Functions |