If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
vat adds up correctly accross spreadsheet but down the columns whe | Boonerball | New Users | 5 | October 20th, 2004 08:45 PM |
print spreadsheet columns as rows down the page in excel | 95YJ | General Discussion | 3 | October 19th, 2004 02:20 AM |
How to update a spreadsheet with years of experience | Michael | General Discussion | 1 | October 11th, 2004 05:28 PM |
Update columns from another table | [email protected] | Running & Setting Up Queries | 2 | July 9th, 2004 08:22 PM |
Update all selected text in a document from a master word | flexdmc | General Discussion | 1 | June 3rd, 2004 12:52 AM |