Linking to Data from Multiple Workbooks

  • Thread starter Thread starter hun1997
  • Start date Start date
H

hun1997

Hi All -- I'm having a little trouble wrapping my mind around this one
so maybe someone has an idea.

I have a few workbooks: a.xls, b.xls, c.xls, etc. that contain larg
amounts of data. Each workbook is identical in structure, however eac
contains different data.

Now I want to create a new workbook that pulls only a small amount o
data from each workbook (depending on the value of dropdown list) an
displays the data (and possibly creates a graph, etc.).

What is the best way to deal with the different file paths, etc.?
Either through Excel functions or VB?

Thanks all
 
Back
Top