Excel 2002 : Any faster way for linking formulas between pages ?
 

Dear Sir,

I frequently need to link formulas between pages at work.

Lets consider the following example whereby I need to summarize data from
other pages within the same file at the Summary Page:


Summary Page
A B


1 =SUM('Page 1'!C2 :C 350)

2 =SUM('Page 1'!A2 :A 250)

3 =SUM('Page 3'!E2 :E 460)


Usually I type in the formula =SUM( and a go to the page to highlight
the range of cells, close the bracket ( ) and strike enter to get the answer
at the cell A in at the Summary Page.

I find that working in this manner is tedious when the number of formulas to
link are many.

May I know is there any smart and faster way of doing it ?


Kind Regards

Low





--
A36B58K641