| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you move the row information by just using one numbered cell? | Excel Discussion (Misc queries) | |||
| Move exact information in a row as you sort a column | Excel Worksheet Functions | |||
| Have VBA delete a group of cells, move information over, then add | Excel Discussion (Misc queries) | |||
| How do I move information between worksheets? | Excel Worksheet Functions | |||
| I want to move my excel information from vertical to horizonta | Excel Discussion (Misc queries) | |||
Hybrid Mode
