Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
Convert String to Function Reference | Excel Worksheet Functions | |||
Can I show a reference value with a string? | Excel Discussion (Misc queries) | |||
dynamic cell reference within a text string | Excel Worksheet Functions | |||
How to get a cell reference of by searchig a text string? | Excel Discussion (Misc queries) |