25.07.2022, 19:12
Hi experts,
I would like to create a summary Excel-sheet which refers to several other Excel-sheet A_1 to Excel sheet A_100.
e.g.
in A1 of summary: =C:\Test\[A_1.xlsx]Sheet1'!$A$1
to
A100 of summary: =C:\Test\[A_100.xlsx]Sheet1'!$A$1
The referencing works well, but I don`t want to define each reference cell by cell.
With concetenate I can create the text for the formulas with the increasing file number easily.
Is there a way to execute this text in another cell as formula to create the references?
Any other idea to solve this is very much welcome. Thanks in advance for your help.
I would like to create a summary Excel-sheet which refers to several other Excel-sheet A_1 to Excel sheet A_100.
e.g.
in A1 of summary: =C:\Test\[A_1.xlsx]Sheet1'!$A$1
to
A100 of summary: =C:\Test\[A_100.xlsx]Sheet1'!$A$1
The referencing works well, but I don`t want to define each reference cell by cell.
With concetenate I can create the text for the formulas with the increasing file number easily.
Is there a way to execute this text in another cell as formula to create the references?
Any other idea to solve this is very much welcome. Thanks in advance for your help.