Buhler... Buhler? -------------- Anyone... Anyone?

I need to figure out how to update a series of fields on one spreadsheet from another:

Sheet1 - Has item numbers (all unique), descriptions and prices in seperate columns
Sheet2 - Has Exact same item numbers, descriptions which may differ from Sheet1 descriptions, and the "New" price in seperate columns

I want the ""New" price in Sheet2 to replace the "Old" price in Sheet1

It's a highly formatted sheet so I don't want to update in a querey in Access and go back... how can I do it in Excel?

You want to use VLOOKUP or HLOOKUP depending on how the spreadsheet is laid out. Give me a call if you have any questions.

on sheet 1, click the box you want replaced, and have it equal the item in sheet 2. for example, new price is $5 on sheet 2 "E23", and on sheet 1, it is $3"B10", click the box saying $3"B10", and type " = ", click sheet 2 and highlight "E23"...


This will change any value in B10 to the value in E23 on second sheet.. i used the B10 and E23 as examples, send the sheet to me, and ill figure it out if you dont understand what im saying

Email sent - Thanks Steve

on sheet 1, click the box you want replaced, and have it equal the item in sheet 2. for example, new price is $5 on sheet 2 "E23", and on sheet 1, it is $3"B10", click the box saying $3"B10", and type " = ", click sheet 2 and highlight "E23"...


This will change any value in B10 to the value in E23 on second sheet.. i used the B10 and E23 as examples, send the sheet to me, and ill figure it out if you dont understand what im saying

Vic,

I replied to Steve's post before I saw yours. I think what I want to do is a little more involved than that because the "New" sheet that has the new values will always be changing. I need to do more than link spreadsheets... I will always be creating new spreadsheets with the new information. I receive new prices, update my database, THEN I export those as Excel spreadsheets. I then take those new spreadsheets and, with the unique values of the part numbers, I want to have my existing spreadsheet --- which is formatted for "public consumption" --- updated with the new prices. The ONLY values I want to change is the new price into the old sheet via the part number. The descriptions from the new sheets can be somewhat "cryptic" because we have an internal description that is different than what our customers may need to see, and the cell references will change each time I export the new prices --- sometimes part numbers are discontinued, sometimes I get new part numbers, etc.

Anyway, I'll see if Steve can figure it out for me and let you know. Thanks for the help...