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 .. |
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 . |
All times are GMT +1. The time now is 06:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com