Update records from one spreadsheet to another

H

homevestors

I am trying to update a old spreadsheet with a new spreadsheet. Th
original spreadsheet is the property records for the county that I liv
in. The new sheet is an update of properties sold. Each sheet uses
unique "PIN" (Property Indentity Number) for every property record i
the county.

How do I match the "PIN's" from the new sheet to the old sheet t
import and update three filelds ("Sale Year", "Sale Month", and "Sal
Price") from the new sheet to the old sheet?

Thanks,

Rob Caldwel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update selected columns from one spreadsheet to another 1
Import from another spreadsheet 1
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Variable data from one spreadsheet sent to new spreadsheet 0
Copy cell value from one worksheet to matching worksheet in another workbook 4
Copying Range From One Sheet to Another 6
Automatically plotting one cell from newly completed sheets 1
Labels Mail Merge Issue 'new record' blank 1

Top