Forum Discussion

Copper Contributor

Mar 26, 2020

Solved

Numbering of a Cell reference in Excel between different files

Hey guys, I have following problem: I want to display selected data from many Excel documents (file names: 10000, 10001, 10002 ...) in a new file as a table. I simply use the following formula: =...

excel

Formulas and Functions

Savia
Mar 26, 2020
TM-41 A lot of things like this can be done with INDIRECT, however that function doesn't work well with cross-workbook references. I think you are likely going to need a macro or Power Query to get this done.

Savia

Iron Contributor

Mar 26, 2020

TM-41 A lot of things like this can be done with INDIRECT, however that function doesn't work well with cross-workbook references. I think you are likely going to need a macro or Power Query to get this done.

TM-41
Copper Contributor
Mar 27, 2020
SaviaThanks for your quick reply. I tried both, but unfortunately I couldn't solve my problem with that either. I have now resigned myself to the variant of generating the formula from other cell contents:
=[10000.xlsx]Table1!$B$8
correspond to
=B$1&$A15&B$2
So I can reproduce the formula as desired and then convert the formulas as values. It's not very elegant, but it works.