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
 

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

auto find xls files and values 1
Linking cells on different sheets within a workbook. 1
Linking cells within workbook with ALL formating 3
VLOOKUP linking to different files 2
linked workbook (cells) does not show entire length of original te 2
How to create a fill down that increments based on the workbook name 0
How to create a fill down that increments based on the workbook name 4
Copy sheet cells into differnt workbook/sheet, How? 0

Top