Hi all I have something id like to do with excel but havent been able
to get it to work. Here is basically what Im trying to do.

I have 2 worksheets in an excel file. I want to be able to put a
number in in worksheet 1 cell a1 and when I put that number in have it
go to worksheet 2 search cell a1 there till if finds the number then
have it take the number across from it in column B and copy that
number back to worksheet 1 and put it in cell b1.

Can anyone help me with this.

Thanks

Jim