software

I am taking a Microsoft Office college course. I have a Web Query on
worksheet one and I reference it in worksheet two, but when I hit enter it
displays a 0.

Do you want to reference the results of the query, or the quert itsekf?

--
AP

quot;ReAnnaquot; gt; a écrit dans le message de
...
gt; I am taking a Microsoft Office college course. I have a Web Query on
gt; worksheet one and I reference it in worksheet two, but when I hit enter it
gt; displays a 0.
I want to reference the results of the query.

quot;Ardus Petusquot; wrote:

gt; Do you want to reference the results of the query, or the quert itsekf?
gt;
gt; --
gt; AP
gt;
gt; quot;ReAnnaquot; gt; a écrit dans le message de
gt; ...
gt; gt; I am taking a Microsoft Office college course. I have a Web Query on
gt; gt; worksheet one and I reference it in worksheet two, but when I hit enter it
gt; gt; displays a 0.
gt;
gt;
gt;

Use INDIRECT. Look in help index

--
Don Guillett
SalesAid Software

quot;ReAnnaquot; gt; wrote in message
...
gt;I want to reference the results of the query.
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt;gt; Do you want to reference the results of the query, or the quert itsekf?
gt;gt;
gt;gt; --
gt;gt; AP
gt;gt;
gt;gt; quot;ReAnnaquot; gt; a écrit dans le message de
gt;gt; ...
gt;gt; gt; I am taking a Microsoft Office college course. I have a Web Query on
gt;gt; gt; worksheet one and I reference it in worksheet two, but when I hit enter
gt;gt; gt; it
gt;gt; gt; displays a 0.
gt;gt;
gt;gt;
gt;gt;
Assuming your Query is named quot;WebQueryquot;, enter the following in sheet2:
=Sheet1!WebQuery

HTH
--
AP

quot;ReAnnaquot; gt; a écrit dans le message de
...
gt; I want to reference the results of the query.
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt; gt; Do you want to reference the results of the query, or the quert itsekf?
gt; gt;
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;ReAnnaquot; gt; a écrit dans le message de
gt; gt; ...
gt; gt; gt; I am taking a Microsoft Office college course. I have a Web Query on
gt; gt; gt; worksheet one and I reference it in worksheet two, but when I hit
enter it
gt; gt; gt; displays a 0.
gt; gt;
gt; gt;
gt; gt;