Hi All!

I'm stuck trying to populate the information from one sheet to another.

Basically, I am wanting the two worksheet to reflect the same information (but it will be displayed differently which is why I need the two), for example:

SHEET #1:
COLUMN A-------------------COLUMN B
John Smith----------------{Need to add number}

SHEET #2:
COLUMN A--------------------COLUMN B
{Need to add name}------------123

So when the number is entered into "Sheet 1/Column B" and equals the number on "Sheet 2/Column B", I am wanting the name from "Sheet 1/Column A" to automatically populate in "Sheet 2/Column A"

Hope that makes sense that that someone can help!!!!!!