ExcelBanter - To Move Cell Information

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - To Move Cell Information (https://www.excelbanter.com/excel-worksheet-functions/141367-move-cell-information.html)

Troy

To Move Cell Information

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

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

All times are GMT +1. The time now is 08:03 PM.