Update selected columns from one spreadsheet to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

homevestors - 21 Oct 2004 16:32 GMT

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

Reply to this Message

Mark - 23 Oct 2004 02:40 GMT

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
excelmarksway@yahoo.com.au

>-----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

action=getinfo&userid=15307

>View this thread: http://www.excelforum.com/showthread.php?threadid=271225
>
>.

Reply to this Message