Add number to a formula from another cell

[jantse]

Hi!
How can I add an input from another cell to a formula?

Formula something like this but these doesn't work
=I000110.xls!$A$INDIRECT(A1), tai
=CONCATENATE("I000110.xls!$A$";A1)


My table should look something like:
A B C
1 6 value from cell A6 from file xxx.xls
2 11 value from cell A11 from file xxx.xls
.
.
10000 14 value from cell A14 from file xxx.xls

If it is not possible I can copy data from xxx.xls to the same workbook but another sheet where the formula is.

Thank you for your answers...!

[ChemistB]

Not sure what you are trying to do. To connect a cell to another open workbook it would be something like this

Please Login or Register  to view this content.

for a closed workbook, you'd need the whole path inside single quote marks e.g.

Please Login or Register  to view this content.

Hope that helps.