Anne Troy
06-29-2005, 06:18 PM
I can never remember how to do this.
Suppose I have a worksheet name in cell A2 (which I do).
Suppose in C2, I want to SUM(C2:C65536) from the worksheet whose name is in A2.
=SUM(SomeWayToGetWorksheetNameFromA2!C2:C65536)
Thanks!
Suppose I have a worksheet name in cell A2 (which I do).
Suppose in C2, I want to SUM(C2:C65536) from the worksheet whose name is in A2.
=SUM(SomeWayToGetWorksheetNameFromA2!C2:C65536)
Thanks!