| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic moving cell Info
Hi
If I add a number in cell A2, I want that number that i put into A2 an the text that I already have in B2 to go to another page in P2. How Can I do this Thanks Troy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatic moving cell Info
in P2 enter =A2&" "&B2
the middle bit is there to have a space between the number and the text. If a2 and b2 are on different sheet.......... =Sheet2!A2&" "&Sheet2!B2 -- Greetings from New Zealand "Troy" wrote in message ... Hi If I add a number in cell A2, I want that number that i put into A2 an the text that I already have in B2 to go to another page in P2. How Can I do this Thanks Troy |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatic moving cell Info
Troy
To actually "move" the data would require VBA because functions and formulas cannot move anything. If you just want the data to appear in P2 on another worksheet.............. In P2 enter =Sheet1!A2 & Sheet1!B2 With a space =Sheet1!A2 & " " & Sheet1!B2 No error check for blank cells. Gord Dibben MS Excel MVP On Mon, 30 Apr 2007 14:38:00 -0700, Troy wrote: Hi If I add a number in cell A2, I want that number that i put into A2 an the text that I already have in B2 to go to another page in P2. How Can I do this Thanks Troy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function? Moving the same info from one worksheet to another. | Excel Worksheet Functions | |||
| Automatic Moving to the Next Cell | Charts and Charting in Excel | |||
| excel, automatic date and time when info gets entered | Excel Worksheet Functions | |||
| How do you perform lookups when the info is always moving? | New Users to Excel | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Hybrid Mode
