How to make one Excel file display data from another Excel file?

D

Dmitry Largovich2015-04-02 15:16:34

excel

Dmitry Largovich, 2015-04-02 15:16:34

Greetings. Tell me please, can you make one Excel file display information from another excel file. Both files will be in the exchanger in the same folder. Those. 1st file is for display, 2nd file is for entering indicators

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

A

Anton Fedoryan, 2015-04-02
@tlatypov

And what is the meaning of this action, describe in more detail? Why can't one file be dispensed with simply by delimiting access rights to it, for example?
You can try pulling up the necessary data with the same VBA script as an option.

R

rosperitus, 2015-04-02
@rosperitus

Link one file to another using formulas (formulas for working with links and arrays), or use the Data Source in the Data section.