Hi,
thx for your reply. I just want to display the text. However When I try the
formula " =INDIRECT("Sheet"&ROWS($1:1)&"!B1")" it was not taking values from
another sheet ie when i tried to enter a value from another sheet in "Sheet"
there was a error.
could u also tell me what an A1-style reference and R1C1-style reference
is? can u pls help me out here.
let me try ann explain my problem more clearly.
1.sheet1, sheet 2..to sheetn all have a common format.
2. Now i have a master sheet in the same workbook in which i want to
consolidate the data.
3. I want to extract data from all these sheets to this master sheet
automatically (ie as i add or delete sheets the master list gets update
automatically).
4. ijust want the data to be displayed there is no need of computations.
"RagDyeR" wrote:
Are you talking about totaling a specific cell on each sheet?
=SUM(Sheet1:Sheet3!D1)
Or, totaling a range:
=SUM(Sheet1:Sheet3!A1:B5)
OR, simply displaying data from a specific cell ( *B1* ) with a formula that
can be incremented by copying down:
=INDIRECT("Sheet"&ROWS($1:1)&"!B1")
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"wunder boy" wrote in message
...
hi robert,
thx for your response.
I have tried that before but the problem with that is when u drag the
formula the sheet numbers dont change eg : Sheet1!D27+Sheet2!D27 when
dragged
will change to Sheet1!D28+Sheet2!D28 or Sheet1!E27+Sheet2!E27. Now this
becomes a problem bcs u have hundreds of sheets to manage..u remove some u
add some. so its kinda painful. Is there anyway out of this?
"robert111" wrote:
in cell A1 of your master sheet enter
=sheet1!A1 + sheet2!A1 + Sheet3!A1 etc etc
--
robert111
------------------------------------------------------------------------
robert111's Profile:
http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=564639