>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.
Edgar L. Bolton, B.S. B.B.A.