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


.

once again - many thanks.

Prior Sayin

wrote in message
...
=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


.