I have a situation in which several (hundreds) of sheets in the same workbook require the same formula to be enterred. Is there a way (short of building a function) that I can enter the formula once in a ‘Legend’ sheet, and then use a reference to that cell in each of the other sheets? for example:
Sheet1: Cell A11: =sum($A$1:$A$10)
or
Sheet1: Cell A11: sum($A$1:$A$10)
?
Then on Sheet 2: Cell A11: (a formula which results in the use of the formula stated on Sheet1!A11)
In other words, on sheet 2 I will place the sum of Sheet2!A1:A10 into Sheet2!A11….
How??? HELP!!!
