Update selected columns from one spreadsheet to another

  • Thread starter Thread starter homevestors
  • Start date Start date
H

homevestors

Hello,

I have two spreadsheets saved as seperate files with different names.
One is sheet is called parcels.xls. The other i
Parcels.Sales.Update.xls.

parcels.xls is a master record of all properties in the county I liv
in. Parcels.Sales.Update.xls is a record of updated sales data for th
properties in parcels.xls.

parcels.xls has a unique PIN (property identifier number) for ever
property on the sheet. Parcels.Sales.Update.xls lists only PIN's tha
have recently sold. Both sheets have a column called SALES_YY (las
date the proerty sold) and a column called SALE_PRICE.

I want to take all of the PIN's from the Parcels.Sales.Update.xls shee
that match the PIN's in the parcels.xls sheet and update the SALES_Y
and SALE_PRICE columns.

Can anyone help me with this? Be easy on me, I am not a speadshee
expert.

Thanks,

Rob Caldwel
 
Hi,
If you do not get a response for this query, send me a
dummy sheet and this info and I might be able to create
something for you. Yes it is free (until I say it's not).

Try out some of my handiwork at:
htpp://au.geocities.com/excelmarksway Excel 97
http://www.geocities.com/excelmarksway Excel 2000

I may not be able to respond straight away but allow a day
or two for a possible result.


regards
Mark E. Philpot
(e-mail address removed)
 
Back
Top