Update selected columns from one spreadsheet to another

Hello,

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

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

parcels.xls has a unique PIN (property identifier number) for every
property on the sheet. Parcels.Sales.Update.xls lists only PIN's that
have recently sold. Both sheets have a column called SALES_YY (last
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 sheet
that match the PIN's in the parcels.xls sheet and update the SALES_YY
and SALE_PRICE columns.

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

Thanks,

Rob Caldwell


--
homevestors
------------------------------------------------------------------------
homevestors's Profile: http://www.excelforum.com/member.php...o&userid=15307
View this thread: http://www.excelforum.com/showthread...hreadid=271225

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


-----Original Message-----

Hello,

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

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

parcels.xls has a unique PIN (property identifier number)
for every
property on the sheet. Parcels.Sales.Update.xls lists
only PIN's that
have recently sold. Both sheets have a column called
SALES_YY (last
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 sheet
that match the PIN's in the parcels.xls sheet and update
the SALES_YY
and SALE_PRICE columns.

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

Thanks,

Rob Caldwell


--
homevestors
----------------------------------------------------------
--------------
homevestors's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=15307
View this thread:
http://www.excelforum.com/showthread...hreadid=271225

.