auto link to cells on different workbooks

T

TIM

What I am trying to do is type a .xls file name in a
cell, which automaticlly lists the next 10 files below
it. Also, automaticlly displaying values of 2 different
cells of each file, next to it.

pt5000

pt5001 34.5467 46.6547
pt5002 3455.56 56.768
pt5003 56.7688 3465.56
etc
 
Top