Convert text to formula in Excel
Solved
XavierMIHB
Posted messages
8
Status
Membre
-
XavierMIHB Posted messages 8 Status Membre -
XavierMIHB Posted messages 8 Status Membre -
Hello everyone,
I'm presenting my problem:
I have several quote files in a folder and I would like to have a summary file with all the elements of these data in comparison mode!
Basically, in my quote files I have:
A1 Item Name
A2 Max Q/year
A3 Series detail
A4 Material type
I would like to have in an annex file:
Data \ File Names Quote 1 Quote 2 Quote 3
Item Name x x x
Max Q/year x x x x
Series detail x x x x
Material type x x x
For this, I can open the different quotes and make links manually (that way if I change something the comparison is still valid).
The thing is that I might end up with about ten files and in reality I have about a hundred lines! And I would have to repeat this for every new estimate (several per week).
So I found a way to create the formulas with the file locations, etc... (you can find all this in the attached file here ==> https://www.cjoint.com/?0IflGSCd8Hj). However, my problem is that these formulas are in text and I would like to activate them as formulas.
Could someone give me a hand?
Thank you!
I'm presenting my problem:
I have several quote files in a folder and I would like to have a summary file with all the elements of these data in comparison mode!
Basically, in my quote files I have:
A1 Item Name
A2 Max Q/year
A3 Series detail
A4 Material type
I would like to have in an annex file:
Data \ File Names Quote 1 Quote 2 Quote 3
Item Name x x x
Max Q/year x x x x
Series detail x x x x
Material type x x x
For this, I can open the different quotes and make links manually (that way if I change something the comparison is still valid).
The thing is that I might end up with about ten files and in reality I have about a hundred lines! And I would have to repeat this for every new estimate (several per week).
So I found a way to create the formulas with the file locations, etc... (you can find all this in the attached file here ==> https://www.cjoint.com/?0IflGSCd8Hj). However, my problem is that these formulas are in text and I would like to activate them as formulas.
Could someone give me a hand?
Thank you!
4 réponses
Hello
to keep it simple:
if you place in C3 the text corresponding to the full address except for the cell, you can simply write:
=INDIRECT($C$3&A4)
otherwise you can compose the address based on the principle:
=INDIRECT("["&C3&"]'Calculation sheet'!"&A4) while respecting all the elements of the required address text according to your files
(I can't see the exact address on my PC, as the links don't exist)
All that's left is to adjust the height to have the correspondence with the cell in A
Best regards
--
To err is human, to persist is diabolical
to keep it simple:
if you place in C3 the text corresponding to the full address except for the cell, you can simply write:
=INDIRECT($C$3&A4)
otherwise you can compose the address based on the principle:
=INDIRECT("["&C3&"]'Calculation sheet'!"&A4) while respecting all the elements of the required address text according to your files
(I can't see the exact address on my PC, as the links don't exist)
All that's left is to adjust the height to have the correspondence with the cell in A
Best regards
--
To err is human, to persist is diabolical