What I am looking for is an easy way to drag a formula so I don't have to
change each cell, and this is happening in multiple cells. What I need is an
increase of ten from the previous cell, but when I do a drag it only
increases by one. I have tried to do a .....+10), but then all I get is 10.
I don't know if this is making any sense, but that is the problem. To try
and be more specific this is how it looks: I have 20 rows with about 40
columns each one having a different formula in the respective column. When I
insert more rows at the end or the middle of the worksheet the formula does
not transfer correctly. What it looks like is: =FoodItems!L309 to
=FoodItems!L310, but what I need it to look like is: =FoodItems!L309 to
=FoodItems!L319. When I try to drag it or create a formula for it, it still
comes out as the first one.

Thanks for the help,