Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto find xls files and values
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 .. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto find xls files and values
Hi Tim,
filename, sheetname question is not clear. by filename do you mean workbook, if so what sheetname and cell is to be looked at. If you do not mean filename at all and those are sheetnames take a look at http://www.mvps.org/dmcritchie/excel/buildtoc2.htm what were you intending on entering -- a value into cell B2 and have the rest generated -- or enter a something anywhere in column a and have next ten rows generated. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "tim" <tim-martin@echometer wrote in message ... What I am trying to do is type a .xls file name in a cell, which automatically 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find missing values while reconciling files? | Excel Discussion (Misc queries) | |||
Where is "open/tools/find/find files that match these criteria"? | Excel Discussion (Misc queries) |