View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andy62 andy62 is offline
external usenet poster
 
Posts: 158
Default 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?