| 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"? |
| 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 | |||
Threaded Mode
