Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Makro | New Users to Excel | |||
How to start a makro | Excel Worksheet Functions | |||
If with a makro | Excel Discussion (Misc queries) | |||
Makro | Excel Discussion (Misc queries) | |||
Import Makro | Excel Programming |