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.

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

--
AP

"ReAnna" <ReAnna@discussions.microsoft.com> a écrit dans le message de
news:986F7D26-54D3-4105-8352-0475492EC7DE@microsoft.com...
> 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.

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" <ReAnna@discussions.microsoft.com> a écrit dans le message de
> news:986F7D26-54D3-4105-8352-0475492EC7DE@microsoft.com...
> > 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.
>
>
>

Use INDIRECT. Look in help index

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"ReAnna" <ReAnna@discussions.microsoft.com> wrote in message
news:0F06D971-80C2-46E6-A101-DD2FCB9BBBEC@microsoft.com...
>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" <ReAnna@discussions.microsoft.com> a écrit dans le message de
>> news:986F7D26-54D3-4105-8352-0475492EC7DE@microsoft.com...
>> > 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.
>>
>>
>>

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

HTH
--
AP

"ReAnna" <ReAnna@discussions.microsoft.com> a écrit dans le message de
news:0F06D971-80C2-46E6-A101-DD2FCB9BBBEC@microsoft.com...
> 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" <ReAnna@discussions.microsoft.com> a écrit dans le message de
> > news:986F7D26-54D3-4105-8352-0475492EC7DE@microsoft.com...
> > > 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.
> >
> >
> >