In any cell on any worksheet you can enter this formula and it will return
the contents of Cell A1 from Sheet 1.

=Sheet1!A1

Change the SheetName and Cell address to suit your needs.

hth
Vaya con Dios,
Chuck, CABGx3



"Keith Nicholls" wrote:

Each week I enter sales 4 products in sheet1.With a column per week and row
per product. Below this I have a cumulative total 2date for each product.
Sheets 2-6 have results 4 each of the previous 5 years and also a similar
table showing the cumulative total 2date.Sheets 7 -11 compare performance
between successive years.Sheet,12, shows results 2date for each product &
each of the 6 years.
At present I enter current figures in sheet 1,then go to sheets2-6 and alter
the sum formula for each row to cover the same number of weeks as on sheet 1.
Simlarly I have to go to the comparisions sheets 7-11 to change the sum
formula there. Is there a way I can alter the row sum formula on sheet 1 and
it automatically alter the corresponding formula on all the other sheets?
save me a lot of time!