Formula or makro help
 

Dear All,

I have big problem becouse i have one file nemed Base.
I need import some of details from other files (1.xls 2.xls 3.xls etc
etc

each next of field in my sheet should have this same formula but from
next file

for examlpe
=2.xls]Arkusz1'!$E$7
=3.xls]Arkusz1'!$E$7
=4.xls]Arkusz1'!$E$7
=1000.xls]Arkusz1'!$E$7

My question is how to do this by automat if only nale of new file
should by change 1,2,3,4,6,...100,n


Thank you fo your help

Formula or makro help
 

Use the row number to determine the number of the file. In the example shown,
I placed the formula in row 1 so it added one to produce:

=2.xls]Arkusz'!$e$7


= "=" & ROW()+1 & ".xls]Arkusz'!$e$7"

Just copy down required rows

HTH

" wrote:

Dear All,

I have big problem becouse i have one file nemed Base.
I need import some of details from other files (1.xls 2.xls 3.xls etc
etc

each next of field in my sheet should have this same formula but from
next file

for examlpe
=2.xls]Arkusz1'!$E$7
=3.xls]Arkusz1'!$E$7
=4.xls]Arkusz1'!$E$7
=1000.xls]Arkusz1'!$E$7

My question is how to do this by automat if only nale of new file
should by change 1,2,3,4,6,...100,n


Thank you fo your help

Formula or makro help
 

Thank you very much but last question...
The final formula should be ='[2.xls]Arkusz'!$e$7 and i dont know
where i should input " '[ "

Your proposition making that i see onlu code " =2.xls]Arkusz'!$e$7
" in the field and i can't take a info from file


Best regards
Jarek





Best regards
Jarek