"roy.okinawa" wrote:
... When I type a number in cell A of sheet 1, column A, is
it possible for all of column A, sheet 2 be checked
for like number and do the transfer of data ..

One way ..

Assuming that data starts in row2 down

In Sheet1
---------
Put in B2:
=IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"",
INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0)))

Copy B2 down as far as required
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--