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

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

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

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

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
--

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

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