Allowing formula to follow an item rather than the worksheet line!
Posted by Gavin on March 14, 2001 3:26 AM
Hi, I hope someone can help and that this is not too basic!
I have a spreadsheet with multiple worksheets.
Each worksheet represents a region with say 30 products and quantities.
One 'master' worksheet contains all the accumulated totals of the other worksheets.
My issue is that I have a basic formula for the accumulations, but the cells in the formula correspond with the worksheet line rather than the product.
This means that if I delete/add a product line to a 'region' worksheet it throws all the fomula out in the accumulated worksheet!