| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling info 2 cells and putting it in one
I have two separate cells, one in worksheet 1 and another worksheet2. I would
like to make it so when I enter info in either of them it will automatically populate a cell on worksheet 3. I would like the cell in worksheet 3 to pull the info from either cell automatically in worksheet 1 or 2. Any thoughts? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pulling info 2 cells and putting it in one
You don't say what you're trying to populate cell 3 with, but if it simply is
the combined contents of the two other cells you can use this in cell 3: =Sheet1!A1&Sheet2!A1 Adjust the cell references as appropriate. To insert a space between them: =Sheet1!A1&" "&Sheet2!A1 "Ian" wrote: I have two separate cells, one in worksheet 1 and another worksheet2. I would like to make it so when I enter info in either of them it will automatically populate a cell on worksheet 3. I would like the cell in worksheet 3 to pull the info from either cell automatically in worksheet 1 or 2. Any thoughts? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pulling info 2 cells and putting it in one
THanks, I think that should work fine!
"andy62" wrote: You don't say what you're trying to populate cell 3 with, but if it simply is the combined contents of the two other cells you can use this in cell 3: =Sheet1!A1&Sheet2!A1 Adjust the cell references as appropriate. To insert a space between them: =Sheet1!A1&" "&Sheet2!A1 "Ian" wrote: I have two separate cells, one in worksheet 1 and another worksheet2. I would like to make it so when I enter info in either of them it will automatically populate a cell on worksheet 3. I would like the cell in worksheet 3 to pull the info from either cell automatically in worksheet 1 or 2. Any thoughts? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pulling info 2 cells and putting it in one
I'm assuming that both sheets will not have an entry at the same time. If
they do then Sheet1 will take precedence. =IF(Sheet1!A1="",IF(Sheet2!A1="","",Sheet2!A1),She et1!A1) -- Biff Microsoft Excel MVP "Ian" wrote in message ... I have two separate cells, one in worksheet 1 and another worksheet2. I would like to make it so when I enter info in either of them it will automatically populate a cell on worksheet 3. I would like the cell in worksheet 3 to pull the info from either cell automatically in worksheet 1 or 2. Any thoughts? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Info | Excel Discussion (Misc queries) | |||
| Pulling info from a list | Excel Worksheet Functions | |||
| pulling 5 lines of info from a sheet | Excel Worksheet Functions | |||
| Pulling info into another sheet | Excel Worksheet Functions | |||
| Pulling parts of information from one cell and putting in another | Excel Discussion (Misc queries) | |||
Hybrid Mode
