Pulling info 2 cells and putting it in one

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ian - 14 Sep 2007 19:00 GMT

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 to this Message

andy62 - 14 Sep 2007 19:12 GMT

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

> 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 to this Message

Ian - 14 Sep 2007 19:24 GMT

THanks, I think that should work fine!

> 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:
[quoted text clipped - 9 lines]
> > 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 to this Message

T. Valko - 14 Sep 2007 19:17 GMT

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),Sheet1!A1)

Signature

Biff
Microsoft Excel MVP

>I have two separate cells, one in worksheet 1 and another worksheet2. I
>would
[quoted text clipped - 3 lines]
> pull
> the info from either cell automatically in worksheet 1 or 2. Any thoughts?

Reply to this Message