thanks
>>I've looked in Excel help, but could not find the
>>answers to the following:
>>
>>1. If I enter a date on sheet1 A10 how do I get
>>that date to automatically appear on sheet2 B12?
>
>formula on sheet2
>=sheet1!A10
>
>>
>>2. I have columns with totals...
>>
>> A12 = sum(a3;a11)
>> A24 = sum(a13;a23)
>> etc.
>>
>>I have 60 totals.
>>Now I need a GRAND Total.
>>Is there a way to do this other than including
>>each total (A12,A24,A36 to A5##) in a series
>>of sum commands?
>
>Looks like there is no way around it, unless you NAME your cells, and then you still must reference sum of names.
Glenn