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

 

[Guest]

=Sheet1!A1

 

[Prior Sayin]

once again - many thanks.

Prior Sayin

=Sheet1!A1