Result Proglem

[Prior Sayin]

Hi again:

Sorry to bother, but I do have another question:

I am using two sheets. I need sheet 2 go gather the result from sheet 1
for a given cell (A1). This cell, A1, has a formula in it that works fine.
Let's say the result of the formula is "apple". I need to be able to gather
the result "apple", not the formula, from sheet one and place it into A1 on
sheet 2. Anybody have an answer?
As I am new to this forum, I hope to be able to contribute sometime
myself.

Thank you so very much.

Prior Sayin

=Sheet1!A1


>-----Original Message-----
>Hi again:
>
> Sorry to bother, but I do have another question:
>
> I am using two sheets. I need sheet 2 go gather the
result from sheet 1
>for a given cell (A1). This cell, A1, has a formula in
it that works fine.
>Let's say the result of the formula is "apple". I need
to be able to gather
>the result "apple", not the formula, from sheet one and
place it into A1 on
>sheet 2. Anybody have an answer?
> As I am new to this forum, I hope to be able to
contribute sometime
>myself.
>
>Thank you so very much.
>
>Prior Sayin
>
>
>.
>

[Prior Sayin]

once again - many thanks.

Prior Sayin

<anonymous@discussions.microsoft.com> wrote in message
news:3e6701c52030$4bc492a0$a601280a@phx.gbl...
> =Sheet1!A1
>
>
>>-----Original Message-----
>>Hi again:
>>
>> Sorry to bother, but I do have another question:
>>
>> I am using two sheets. I need sheet 2 go gather the
> result from sheet 1
>>for a given cell (A1). This cell, A1, has a formula in
> it that works fine.
>>Let's say the result of the formula is "apple". I need
> to be able to gather
>>the result "apple", not the formula, from sheet one and
> place it into A1 on
>>sheet 2. Anybody have an answer?
>> As I am new to this forum, I hope to be able to
> contribute sometime
>>myself.
>>
>>Thank you so very much.
>>
>>Prior Sayin
>>
>>
>>.
>>