Import from another spreadsheet

[homevestors]

I am trying to update a very large spreadsheet (100k + records) with a
updated spreadsheet. The original spreadsheet is the property record
for the county that I live in. The new sheet is an update of propertie
sold. Each sheet uses a unique "PIN" (Property Indentity Number) fo
every property record in the county.

How do I match the "PIN's" from the new sheet to the old sheet. I woul
only want to import and update three filelds ("Sale Year", "Sale Month"
and "Sale Price") from the new sheet to the old sheet.

Thanks,

Rob Caldwel

 

[Dave Peterson]

If that 100k records isn't a typo, then you're not using a single excel
worksheet.

If it is a typo, then you may want to look at some of the ways Chip Pearson has
on his site:

http://www.cpearson.com/excel/duplicat.htm

(he has some worksheet formulas, some macros)