reference to other sheet as a string
 

Hi, I need to use the following formula =OFFSET('HW - TCO'!B7,0,-1)
HW - TCO is reference to another sheet in my excel. the name of the sheet is
actually string which should be manipulate forexample : HW appears under cell
A1...TCO is a result of other string manipulating. but when i try to write
the formula: =offset(' ... and then "range("a1")&... it always fell!!!
i need help! thanks

reference to other sheet as a string
 

miri tz.;297382 Wrote:
Hi, I need to use the following formula =OFFSET('HW - TCO'!B7,0,-1)
HW - TCO is reference to another sheet in my excel. the name of the
sheet is
actually string which should be manipulate forexample : HW appears
under cell
A1...TCO is a result of other string manipulating. but when i try to
write
the formula: =offset(' ... and then "range("a1")&... it always fell!!!
i need help! thanks

Hi,
maybe you are looking for the INDIRECT function

try=offset(indirect("'"&A1&"-"&"TCO"&"'!b7"),0,-1)

replace the strings in the indirect function with cell references where
necessary.

HTH


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=83122

reference to other sheet as a string
 

=offset(indirect("'" & $a$1 & " - " & yourTCOFormula & "'!b7"), 0, -1)



miri tz. wrote:

Hi, I need to use the following formula =OFFSET('HW - TCO'!B7,0,-1)
HW - TCO is reference to another sheet in my excel. the name of the sheet is
actually string which should be manipulate forexample : HW appears under cell
A1...TCO is a result of other string manipulating. but when i try to write
the formula: =offset(' ... and then "range("a1")&... it always fell!!!
i need help! thanks

--

Dave Peterson