Below is an example of what it does now. When I type a number in column A on
the Input sheet it looks for a match on the Master sheet, column A and copies
the data from column B to column B on the Input sheet. However, when I type
the same number further down the column I want it to scan the Master file
column for a matching number and copy. I don't want to have the same number
listed more than once on the master sheet. Hope that clears it up.

Input sheet
Column A Column B
292001 17

Master sheet
Column A
292001 17



"Max" wrote:

"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
--