If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking Formula
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? |
#2
|
|||
|
|||
Linking Formula
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 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? |
#3
|
|||
|
|||
Linking Formula
=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? |
Thread Tools | |
Display Modes | |
|
|