Remover number from one sheet to another

  • Thread starter Thread starter Therese
  • Start date Start date
T

Therese

Hi
I have got several sheets in one.
In 'Sheet!Apple'!A1, I have the number 8.
I want the number 8 to appear in 'Sheet!Banana'!A1, if I f.ex. put a x on
'Sheet!Apple'!A1.
Is this possible??
Thanks
Therese
 
I am a bit confused.

You have an 8 in 'Sheet!Apple'!A1

If you change that 8 to an x, you want 'Sheet!Banana'!A1 to equal 8?

I think you may have a typo in your post but............?

=IF('Sheet!Apple'!A1="x", 8,"not x") entered in 'Sheet!Banana'!A1


Gord Dibben MS Excel MVP
 
Back
Top