software

Hiya guys and gals

I have the following code;

=INDIRECT(quot;E2quot;!, E7)

From what i understand from the help files this should work, unless i
am being stupid (highly probable)

What I want it to do is for the host cell to display the value of cell
E7 from another worksheet, the name of the work sheet is in cell E2.

Like i said i have searched the help files and this seems to be the
method that is best.

Regards
James--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=515417=INDIRECT(quot;'quot;amp;E2amp;quot;'!quot;amp;E7)--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;superkopitequot; gt;
wrote in message
...
gt;
gt; Hiya guys and gals
gt;
gt; I have the following code;
gt;
gt; =INDIRECT(quot;E2quot;!, E7)
gt;
gt; From what i understand from the help files this should work, unless i
gt; am being stupid (highly probable)
gt;
gt; What I want it to do is for the host cell to display the value of cell
gt; E7 from another worksheet, the name of the work sheet is in cell E2.
gt;
gt; Like i said i have searched the help files and this seems to be the
gt; method that is best.
gt;
gt; Regards
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile:
www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread: www.excelforum.com/showthread...hreadid=515417
gt;
=INDIRECT(quot;Sheet2!quot;amp;E7)

Is your sheet called E2?

You probably mean

=INDIRECT(E2amp;quot;!quot;amp;E7)

??--
Kind regards,

Niek Otten

quot;superkopitequot; gt;
wrote in message
...
gt;
gt; Hiya guys and gals
gt;
gt; I have the following code;
gt;
gt; =INDIRECT(quot;E2quot;!, E7)
gt;
gt; From what i understand from the help files this should work, unless i
gt; am being stupid (highly probable)
gt;
gt; What I want it to do is for the host cell to display the value of cell
gt; E7 from another worksheet, the name of the work sheet is in cell E2.
gt;
gt; Like i said i have searched the help files and this seems to be the
gt; method that is best.
gt;
gt; Regards
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread: www.excelforum.com/showthread...hreadid=515417
gt;

This seems to throw back an #ref error

Regards

James--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=515417Let's say cell E2 contains the text Sheet3
then
=INDIRECT(E2 amp; quot;!quot; amp; quot;E7quot;) is what you want.The trick is that between the parenthesis you want a string that represents
an address
--
Gary's Studentquot;superkopitequot; wrote:

gt;
gt; Hiya guys and gals
gt;
gt; I have the following code;
gt;
gt; =INDIRECT(quot;E2quot;!, E7)
gt;
gt; From what i understand from the help files this should work, unless i
gt; am being stupid (highly probable)
gt;
gt; What I want it to do is for the host cell to display the value of cell
gt; E7 from another worksheet, the name of the work sheet is in cell E2.
gt;
gt; Like i said i have searched the help files and this seems to be the
gt; method that is best.
gt;
gt; Regards
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread: www.excelforum.com/showthread...hreadid=515417
gt;
gt;


hi Nek

no that doesn't seem to work either

The name of the worksheet is located in cell E7

Regards

James--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=515417=INDIRECT(E2amp;quot;!E7quot;)

If E2 contains a string with spaces (ie: quot;Sheet 1quot; instead of quot;Sheet1quot;) you
will need to use this formula

=INDIRECT(quot;'quot;amp;E2amp;quot;'quot;amp;quot;!E7quot;)

You want a text string that looks like this...
Sheet1!E7
or
'Sheet 1'!E7

quot;superkopitequot; wrote:

gt;
gt; Hiya guys and gals
gt;
gt; I have the following code;
gt;
gt; =INDIRECT(quot;E2quot;!, E7)
gt;
gt; From what i understand from the help files this should work, unless i
gt; am being stupid (highly probable)
gt;
gt; What I want it to do is for the host cell to display the value of cell
gt; E7 from another worksheet, the name of the work sheet is in cell E2.
gt;
gt; Like i said i have searched the help files and this seems to be the
gt; method that is best.
gt;
gt; Regards
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread: www.excelforum.com/showthread...hreadid=515417
gt;
gt;


For some reason this is still returning a #ref error.

It is also highlighting the E2 part of the formula to indicate that
this the main part of the problem

Regards

James--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=515417I bet the name of the worksheet is misspelled in E2.

superkopite wrote:
gt;
gt; This seems to throw back an #ref error
gt;
gt; Regards
gt;
gt; James
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread: www.excelforum.com/showthread...hreadid=515417

--

Dave Peterson

Maybe this then

=INDIRECT(quot;'quot;amp;E2amp;quot;'!E7quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;superkopitequot; gt;
wrote in message
...
gt;
gt; This seems to throw back an #ref error
gt;
gt; Regards
gt;
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile:
www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread: www.excelforum.com/showthread...hreadid=515417
gt;