How do I reference a Web Query on another sheet?
 

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.

How do I reference a Web Query on another sheet?
 

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

--
AP

"ReAnna" a écrit dans le message de
...
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.

How do I reference a Web Query on another sheet?
 

I want to reference the results of the query.

"Ardus Petus" wrote:

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

--
AP

"ReAnna" a écrit dans le message de
...
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.

How do I reference a Web Query on another sheet?
 

Use INDIRECT. Look in help index

--
Don Guillett
SalesAid Software

"ReAnna" wrote in message
...
I want to reference the results of the query.

"Ardus Petus" wrote:

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

--
AP

"ReAnna" a écrit dans le message de
...
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.

How do I reference a Web Query on another sheet?
 

Assuming your Query is named "WebQuery", enter the following in sheet2:
=Sheet1!WebQuery

HTH
--
AP

"ReAnna" a écrit dans le message de
...
I want to reference the results of the query.

"Ardus Petus" wrote:

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

--
AP

"ReAnna" a écrit dans le message de
...
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.