M
Mr. Low
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
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