Refer to a workbook
Solved
André Roussel
-
André Roussel -
André Roussel -
Hello,
I am going to ask a question that I think is a bit simpler than usual:
Is it possible to refer to a cell in a different Excel workbook in a formula?
Thank you in advance for your answers.
Best regards,
André Roussel
Configuration: Windows / Chrome 59.0.3071.115
I am going to ask a question that I think is a bit simpler than usual:
Is it possible to refer to a cell in a different Excel workbook in a formula?
Thank you in advance for your answers.
Best regards,
André Roussel
Configuration: Windows / Chrome 59.0.3071.115
3 answers
-
Hello André Roussel
To refer to another workbook
Both workbooks must be open
In the second workbook, in the relevant cell, enter ""="" and go to the first workbook, click on the corresponding cell, and validate by pressing ""enter""
This cell will take the value from the first workbook
Both workbooks must be in the same folder
Check if this works for you?
--
Practice makes perfect. - It's at the foot of the wall that one sees the mason - one always learns from their mistakes. -
Hello
yes, of course, but the link will only work if the source workbook is open
select your cell
write your formula by clicking on the source cells in the other workbook and the addresses will automatically appear
best regards
--
The quality of the answer mainly depends on the clarity of the question, thank you! -