How do I update information bewteen two spreadsheets?

[Jerry]

Using Excel 2000 with moderate skills.

Have two spreadsheets that contain a list of products (“store-inventory†and
“website-inventoryâ€), though both list may not have the same amount of
products, they do use the same product codes. How would I go about updating
the inventory column from the store-inventory spreadsheet to the
website-inventory?

Thank you, Jerry

 

[Sheeloo]

What do you mean by 'updating'? Pl. give an example.

Also sample data for a few rows in both the spreadsheets (in same workbook
or different workbooks?)

See VLOOKUP in Help... it might solve your problem.

 

[Jerry]

Here is what I need, but I cannot seem to follow it, my Excel skill are not
as good as they use to be. I need a little more detailed steps explanation.

http://www.microsoft.com/office/com...sers&mid=04196f7b-b903-4a93-b6c9-9cdcd5dc6be4


Thank you, Jerry

 

[Sheeloo]

I don't think I will be able to improve upon the explanation.

You can send the files to me and I will do the needful (with explanation)

 

[Jerry]

Thank you, the is very nice of you. How do I go about sending you the two
files?

Thank you, Jerry

 

[Sheeloo]

add @hotmail.com to
to_sheeloo

or click my name for insructions