Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Indirect reference (again?)
Hi I have a question Iam not able to find exact answer and my excel skills are not very high-end So, I have a Excel document that has Main worksheet and several (inreasing) number of worksheets, named by customer. I would like to get information from each customer worksheet to main sheet, but the source worksheet name should be indirect and recived from main sheet. I have tried several versions =INDORECT("'" & D208 & "'!E10") =INDIRECT(D208 & "!E10") etc... where D208 is name of company (also name of the sheet data should be captured) and E10 cell of cource sheet Can anyone give me correct direction? Regards Hundikoer -- Hundikoer ------------------------------------------------------------------------ Hundikoer's Profile: http://www.excelforum.com/member.php...o&userid=28301 View this thread: http://www.excelforum.com/showthread...hreadid=478715 |
#2
|
|||
|
|||
Indirect reference (again?)
Think
=INDIRECT(D208 & "!E10") should work, assuming D208 contains the actual sheetname Maybe you could also try: =INDIRECT("'"& TRIM(D208) & "'!E10") Ensure that the actual sheetnames (the names entered on the tabs) match exactly* with what's in D208, etc. Check for any inadvertent extraneous leading, trailing or in-between "white" space(s) in the actual sheetname. These may not readily be visible and would throw the matching off (You'll get #REF!). *case aside -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Hundikoer" wrote in message ... Hi I have a question Iam not able to find exact answer and my excel skills are not very high-end So, I have a Excel document that has Main worksheet and several (inreasing) number of worksheets, named by customer. I would like to get information from each customer worksheet to main sheet, but the source worksheet name should be indirect and recived from main sheet. I have tried several versions =INDORECT("'" & D208 & "'!E10") =INDIRECT(D208 & "!E10") etc... where D208 is name of company (also name of the sheet data should be captured) and E10 cell of cource sheet Can anyone give me correct direction? Regards Hundikoer -- Hundikoer ------------------------------------------------------------------------ Hundikoer's Profile: http://www.excelforum.com/member.php...o&userid=28301 View this thread: http://www.excelforum.com/showthread...hreadid=478715 |
#3
|
|||
|
|||
Indirect reference (again?)
=INDIRECT("'"&D208&"'!E10")
-- HTH RP (remove nothere from the email address if mailing direct) "Hundikoer" wrote in message ... Hi I have a question Iam not able to find exact answer and my excel skills are not very high-end So, I have a Excel document that has Main worksheet and several (inreasing) number of worksheets, named by customer. I would like to get information from each customer worksheet to main sheet, but the source worksheet name should be indirect and recived from main sheet. I have tried several versions =INDORECT("'" & D208 & "'!E10") =INDIRECT(D208 & "!E10") etc... where D208 is name of company (also name of the sheet data should be captured) and E10 cell of cource sheet Can anyone give me correct direction? Regards Hundikoer -- Hundikoer ------------------------------------------------------------------------ Hundikoer's Profile: http://www.excelforum.com/member.php...o&userid=28301 View this thread: http://www.excelforum.com/showthread...hreadid=478715 |
#4
|
|||
|
|||
Indirect reference (again?)
Thanks Max Tha last solution was perfect Main problem was with spaces Regards Hundikoer -- Hundikoer ------------------------------------------------------------------------ Hundikoer's Profile: http://www.excelforum.com/member.php...o&userid=28301 View this thread: http://www.excelforum.com/showthread...hreadid=478715 |
#5
|
|||
|
|||
Indirect reference (again?)
"Hundikoer" wrote:
Thanks Max Tha last solution was perfect Main problem was with spaces You're welcome ! Glad you found out what wasn't working .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#6
|
|||
|
|||
Indirect reference (again?)
The worksheets are in the same workbook? And H569 has the name of that
worksheet? =HYPERLINK("#'"&H569&"'!a1") Hundikoer wrote: Now one more question I have used hyperlinks, to open folders, that use dynamic (indirect names) like: =HYPERLINK("\\Smm\IntShared\Es\Data\"&H569&"";"Fol der") and like in initial question I had in the topic. But how can I open a worksheet in same workbook (do not want to use the name of file) when worksheet name is located for excample in cell H569? Regards Hundikoer -- Hundikoer ------------------------------------------------------------------------ Hundikoer's Profile: http://www.excelforum.com/member.php...o&userid=28301 View this thread: http://www.excelforum.com/showthread...hreadid=478715 -- Dave Peterson |
#7
|
|||
|
|||
Indirect reference (again?)
Thanks! It was perfect I am impressed... BR Lauri -- Hundikoer ------------------------------------------------------------------------ Hundikoer's Profile: http://www.excelforum.com/member.php...o&userid=28301 View this thread: http://www.excelforum.com/showthread...hreadid=478715 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect reference to another sheet that can be dragged | Excel Worksheet Functions | |||
indirect function to reference cell on different sheet | Excel Worksheet Functions | |||
Indirect and Address in Reference to other sheets | Excel Worksheet Functions | |||
indirect cell reference using copies of worksheets in same workboo | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |