Hi All,
Is there a way that I can change my links in 1 replace?
For Example below.
I want to get the sum of column A for every sheet.
I used the formula =SUM(sheet1!A:A)
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Reference[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]sheet1[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]sheet2[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]sheet3[/TD]
[TD]70[/TD]
[/TR]
</tbody>[/TABLE]
Is there a way that I can do this easily without manually updating the formula?
Thanks,
Gerald_24
Is there a way that I can change my links in 1 replace?
For Example below.
I want to get the sum of column A for every sheet.
I used the formula =SUM(sheet1!A:A)
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Reference[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]sheet1[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]sheet2[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]sheet3[/TD]
[TD]70[/TD]
[/TR]
</tbody>[/TABLE]
Is there a way that I can do this easily without manually updating the formula?
Thanks,
Gerald_24