ok here goes...

what i was wondering is hard to explain so ill explain it in an small example...

i have 3 sheets in my workbook, 'week1', 'week2' and 'total'

i enter the number 10 in cell A1 on the 'week1' sheet and the number 3 in cell B2 on the 'week2' sheet

on the 'total' sheet in cell C3 i enter the formula =week1!A1+week2!B2 and it adds it obviously.

but i then want to delete sheets 'week1' and 'week2' yet keep the value 13 in cell C3 on the 'total' sheet WITHOUT having to type it in myself.

ignore the macro part i would like to know just how to lock the values to the cells.

is this even possible? im using excel 2000 but have access to 2003 if necessary. any response would be wonderful :)

thanks in advance.