Connecting Separate Spreadsheets together

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.
 
E

Eric

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help needed 1
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
identifying data from a separate worksheet 1
fill in data that is not empty 1
Need help referencing b/w sheets for school project 0
Linking Separate Spreadsheets Together 2
Retrieve data based on 3 criteria 3
Markup/Cost formula help... 1

Top