To Move Cell Information

[Guest]

Please Help

If in a worksheet, if i put a number in cell A11 on page 1 I want the
number in A11 and the words that i already have in B11 to automatic move to
G6 in the same work sheet But on page 2. But if I do not put any number in
A11 Then I do not want any of that information to show up on page 2 G6

Thanks
Troy

 

[Fred Smith]

In G6, try:

=if(a11="","",A11&B11)

I can't figure out what you mean by pages. Do you mean in a different worksheet?