How do I update information bewteen two spreadsheets?
 

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

How do I update information bewteen two spreadsheets?
 

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" wrote:

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

How do I update information bewteen two spreadsheets?
 

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/comm...9-9cdcd5dc6be4


Thank you, Jerry

"Sheeloo" wrote:

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" wrote:

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

How do I update information bewteen two spreadsheets?
 

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" wrote:

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/comm...9-9cdcd5dc6be4


Thank you, Jerry

"Sheeloo" wrote:

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" wrote:

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

How do I update information bewteen two spreadsheets?
 

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

Thank you, Jerry

"Sheeloo" wrote:

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" wrote:

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/comm...9-9cdcd5dc6be4


Thank you, Jerry

"Sheeloo" wrote:

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" wrote:

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

How do I update information bewteen two spreadsheets?
 

add @hotmail.com to
to_sheeloo

or click my name for insructions

"Jerry" wrote:

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

Thank you, Jerry

"Sheeloo" wrote:

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" wrote:

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/comm...9-9cdcd5dc6be4


Thank you, Jerry

"Sheeloo" wrote:

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" wrote:

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