View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default To Move Cell Information

In G6, try:

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

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

--
Regards,
Fred


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