how do I use a file list to recall data from listed files?

G

Guest

I have a huge excel master workbook with 30 worksheets to report data from 50
other workbooks... to add a single workbook to the master file is a huge
task...

I want to create a list of files to call in and automatically add to the
growing list.

Example:

where Filename "test.xls" is in cell A2

='[A2]sheet1!'F13

having said that I want A2 to step up as I drag and expand the list...
 
G

Gord Dibben

Dave

With a list of workbook names in A2:A10 and "F13" in B2

=INDIRECT("'["&A2&"]Sheet1'!"&$B$2)


Gord Dibben MS Excel MVP
 

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

how to use if formula in list (data validation list) 1
my vlookup path changes when I open the file 1
Linking data from one worksheet to another... 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Compile data from several workbooks 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Copy Data from One Spreadsheet to Another ?????? 5
Is it possible to add rows to a range using input form 1

Top