Display Value

Closed
excelnewbie - Nov 30, 2009 at 12:11 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Nov 30, 2009 at 05:51 AM
Hello,
My problem is simple for you guys I guess, but I could not find a way on my own. I hope you can help me out.

I have two sheets, lets say, Sheet1 and Sheet2.

On sheet 2, I have cells A1 and A2. A1 has the value "Great job!" I want to create a formula on A2 that when TRUE, it displays the value of A1 on a specified cell on Sheet 1.

I would really appreciate any help you can give guys. Thanks a lot in advance.

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Nov 30, 2009 at 05:51 AM
quote
formula on A2 that when TRUE
unquote
what mant by that sentence

quote
A1 on a specified cell on Sheet 1.
unquoe

what is the specified cell. do you want it to decide only at the end
0