How do I reference a Web Query on another sheet?

[ReAnna]

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.

 

[Ardus Petus]

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

 

[ReAnna]

I want to reference the results of the query.

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

 

[Don Guillett]

Use INDIRECT. Look in help index

 

[Ardus Petus]

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

HTH