Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula changing
is there anyway to change formulas when my cells change we use an excell sheet to pull our products and basically we tally items in one set of cells (i.e B2, C2) and then use baisc formulas (=C2)to these display these number on a seperate part of the page we print to pull inventory from i need to add things to the sheet (changing b2 down to b5, only rows added), is there any way to change formulas easily without rewriting them all (i.e. adding 3 to the =b2 fromula instead of going through and changing it to =b5) There are a few hundred formulas to change and i don't wnat to go back & change them 1 by 1. THanks for any help, -- hookahbrain ------------------------------------------------------------------------ hookahbrain's Profile: http://www.excelforum.com/member.php...o&userid=30645 View this thread: http://www.excelforum.com/showthread...hreadid=503047 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula changing
If you use Edit | Insert | Rows [or Columns] or Edit | Insert | Cells, Excel
should take care of this for you automatically. "hookahbrain" wrote: is there anyway to change formulas when my cells change we use an excell sheet to pull our products and basically we tally items in one set of cells (i.e B2, C2) and then use baisc formulas (=C2)to these display these number on a seperate part of the page we print to pull inventory from i need to add things to the sheet (changing b2 down to b5, only rows added), is there any way to change formulas easily without rewriting them all (i.e. adding 3 to the =b2 fromula instead of going through and changing it to =b5) There are a few hundred formulas to change and i don't wnat to go back & change them 1 by 1. THanks for any help, -- hookahbrain ------------------------------------------------------------------------ hookahbrain's Profile: http://www.excelforum.com/member.php...o&userid=30645 View this thread: http://www.excelforum.com/showthread...hreadid=503047 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula changing
this only changes the location of the rows/cells, it does not help formulas If you use Edit | Insert | Rows [or Columns] or Edit | Insert | Cells, Excel should take care of this for you automatically. "hookahbrain" wrote: is there anyway to change formulas when my cells change we use an excell sheet to pull our products and basically we tally items in one set of cells (i.e B2, C2) and then use baisc formulas (=C2)to these display these number on a seperate part of the page we print to pull inventory from i need to add things to the sheet (changing b2 down to b5, only rows added), is there any way to change formulas easily without rewriting them all (i.e. adding 3 to the =b2 fromula instead of going through and changing it to =b5) There are a few hundred formulas to change and i don't wnat to go back & change them 1 by 1. THanks for any help, -- hookahbrain -- hookahbrain ------------------------------------------------------------------------ hookahbrain's Profile: http://www.excelforum.com/member.php...o&userid=30645 View this thread: http://www.excelforum.com/showthread...hreadid=503047 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula changing
Maybe you can give a more detailed example? When I tried this in my
spreadsheet, Excel automatically updated the reference from B2 to B5 when I inserted 3 rows above B2. So if my formula (e.g., =B2+C2) was in D17 (or even on another worksheet), when I inserted 3 rows above B2, Excel automatically made D17 (now D20) look like =B5+C5. So I guess I'm not understanding your question. "hookahbrain" wrote: this only changes the location of the rows/cells, it does not help formulas If you use Edit | Insert | Rows [or Columns] or Edit | Insert | Cells, Excel should take care of this for you automatically. "hookahbrain" wrote: is there anyway to change formulas when my cells change we use an excell sheet to pull our products and basically we tally items in one set of cells (i.e B2, C2) and then use baisc formulas (=C2)to these display these number on a seperate part of the page we print to pull inventory from i need to add things to the sheet (changing b2 down to b5, only rows added), is there any way to change formulas easily without rewriting them all (i.e. adding 3 to the =b2 fromula instead of going through and changing it to =b5) There are a few hundred formulas to change and i don't wnat to go back & change them 1 by 1. THanks for any help, -- hookahbrain -- hookahbrain ------------------------------------------------------------------------ hookahbrain's Profile: http://www.excelforum.com/member.php...o&userid=30645 View this thread: http://www.excelforum.com/showthread...hreadid=503047 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Changing a Formula in Conditional Formatting | Excel Worksheet Functions | |||
formula with changing cell ranges | Excel Worksheet Functions | |||
A cell reference in a formula changing | Excel Worksheet Functions | |||
what is the formula for changing the same cell on different sheet. | Excel Worksheet Functions |