View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Ardus Petus
 
Posts: n/a
Default 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.