Linking Separate Spreadsheets Together

[H SELIM]

Using Excel 2000, I have worksheet #1 with a product price list containing
the following columns:

- product ID
- name
- description
- cost
- price
- taxable
- active
- product page url
- image url

I want to connect 3 additional worksheets (#2, #3 & #4) that will contain
the same data but NOT in the same column order. My objective is to have the
data in #2, #3 & #4 be automatically updated when any changes occur in
worksheet #1. Your assistance is kindly appreciated.

Hal.

 

[Jonathan Rynd]

I want to connect 3 additional worksheets (#2, #3 & #4) that will contain
the same data but NOT in the same column order.

Do you mean the same column order, or the same row order?

A row, also called a record, is all the information about one individual
product.

Are you saying that the products are going to be in a different order, or
the columns are going to be in a different order?

 

[Dave Peterson]

Maybe you could use =vlookup() to return the values.

=if(a1="","",vlookup(a1,ProductPriceList!$a:$i,8,false))

would return the 8th column (Product page URL) if the =vlookup() found a match
in the Product Id column.

If no match was found, you'd see #n/a.

You could hide them like:
=IF(A1="","",IF(ISERROR(VLOOKUP(A1,productpricelist!$A:$I,8,FALSE)),"Missing",
VLOOKUP(A1,productpricelist!$A:$I,8,FALSE)))

(all one cell)