Prev: Brugervenlig udfyldning
Next: Shared Workbook opens as read-only
From: Don S Don on 30 Mar 2010 15:10
I have a workbook with multiple data sheets. Each data sheet has a sum total
in cell B4. I created a summary sheet to pull all the totals into it. I
entered the following linking formula: ='(1)'!$B$4, now I want to drag this
formula down and have it automatically change to the next sheet. For example
='(2)'!$B$4, ='(3)'!$B$4, ='(4)'!$B$4 and so on… Is this possible?
From: Gord Dibben on 30 Mar 2010 15:49
In A1 of summary sheet.

=INDIRECT(ROW()&"!B4")

Copy down.

Assumes your sheets are named 1, 2, 3, 4 etc.

If named Sheet1, Sheet2 etc.

=INDIRECT("Sheet" & (ROW()) & "!B4")


Gord Dibben MS Excel MVP


On Tue, 30 Mar 2010 12:10:01 -0700, Don S <Don S(a)discussions.microsoft.com>
wrote:

>I have a workbook with multiple data sheets. Each data sheet has a sum total
>in cell B4. I created a summary sheet to pull all the totals into it. I
>entered the following linking formula: ='(1)'!$B$4, now I want to drag this
>formula down and have it automatically change to the next sheet. For example
>='(2)'!$B$4, ='(3)'!$B$4, ='(4)'!$B$4 and so on� Is this possible?

From: Teethless mama on 30 Mar 2010 15:56
=INDIRECT("'("&ROW(A1)&")"&"'!B4")

copy down



"Don S" wrote:

> I have a workbook with multiple data sheets. Each data sheet has a sum total
> in cell B4. I created a summary sheet to pull all the totals into it. I
> entered the following linking formula: ='(1)'!$B$4, now I want to drag this
> formula down and have it automatically change to the next sheet. For example
> ='(2)'!$B$4, ='(3)'!$B$4, ='(4)'!$B$4 and so on… Is this possible?
 | 
Pages: 1
Prev: Brugervenlig udfyldning
Next: Shared Workbook opens as read-only