Hi!

With both workbooks open you could use a Vlookup formula to get the data
from fileA to fileB. Then after that was completed you could convert the
formulas to constants.

Assume data in fileA is on Sheet1 in the range A2:C100

ID's in fileB are on Sheet1 in the range A2:A50

In B2 of fileB use a formula like this:

=VLOOKUP($A2,[fileA.xls]Sheet1!$A$2:$C$100,COLUMN(B$1),0)

Copy across to C2 then down as needed.

Once all the data is returned and you're satisfied, select fileB columns B
and C and then do copy/paste special/values.

Biff

"JackSpam" wrote in message
...
I wasn't sure if this would require VB or not so I've put this in the
General Question group.
I have 2 workbooks where the first 3 columns of each row (after a title
row)
consist of an ID number, a North coordinate and an East Coordinate.
Workbook
A is complete in that every ID for our system is included along with the
coresponding North and East coords.
Workbook B includes a subset of the IDs and only some of the IDs have
their
coords in columns B and C. How do I import the coords into Workbook B
without having to copy/paste a thousand or more times. Thanks in advance
for
any help.