quickjump problems

  • Thread starter Thread starter zuapfly
  • Start date Start date
Z

zuapfly

hi, i want to make a file that can calculate numbers from differen
excelfiles.

therefore i want to make a cell in this file in which you can enter th
name of an excel-file. Another cell where i can put the range for th
first variable in the excel-file, Another cell where i can put th
range for the other variable in the excel-file...etc...

please take a look at the simple dummyfile i put in attachment..

Attachment filename: results.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62344
 
Hi
First you should show a little bit of patience. You expect
an answer after 23 minutes :-)

For your question:
- download the free add-in Morefunc.xll
(http://longre.free.fr/english/)

- Now enter the following data in your cells
A1: path of your file. e.g.
C:\temp\

A2: name of your file. e.g.
test.xls

A3: sheetname. e.g.
sheet2

A4: cell reference. e.g.
X1

Now use the formula
=INDIRECT.EXT("'" & A1 & "[" & A2 & "]" & A3 & "'!" & A4)
 
And, please only post in ONE group. See my ans elsewhere

--
Don Guillett
SalesAid Software
(e-mail address removed)
Frank Kabel said:
Hi
First you should show a little bit of patience. You expect
an answer after 23 minutes :-)

For your question:
- download the free add-in Morefunc.xll
(http://longre.free.fr/english/)

- Now enter the following data in your cells
A1: path of your file. e.g.
C:\temp\

A2: name of your file. e.g.
test.xls

A3: sheetname. e.g.
sheet2

A4: cell reference. e.g.
X1

Now use the formula
=INDIRECT.EXT("'" & A1 & "[" & A2 & "]" & A3 & "'!" & A4)



-----Original Message-----
hi, i want to make a file that can calculate numbers from different
excelfiles.

therefore i want to make a cell in this file in which you can enter the
name of an excel-file. Another cell where i can put the range for the
first variable in the excel-file, Another cell where i can put the
range for the other variable in the excel-file...etc...

please take a look at the simple dummyfile i put in attachment...

Attachment filename: results.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=623449
Click to expand...
Click to expand...
 
Back
Top