Connecting Separate Spreadsheets together

  • Thread starter Thread starter H SELIM
  • Start date Start date
H

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.
 
It sounds like a vlookup should work for you. Put the
lookups in spreadsheets 2, 3 and 4 making sure that the
column index number is referencing the appropriate column
in sreadsheet #1 and it should update.

If I am missing a dynamic of your question please repost.

Eric
 
Back
Top