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