Sending data between two excel files

[ajl_ahmed]

Can I send a cell value of an excel file into another cell of another excel file? How can do that if it is possible?

[#2 · Accepted solution]

Hi @ajl_ahmed 

You can do it the other way, call data from another workbook.

If you have two workbooks, Book1 and Book2, and you are working in Book1 and you want to get a data from book2 directly from sheet1 cell A1, you can use this formula:

='[book2.xlsx]sheet1'!A1

[#3]

If I have more than 20 excel files and I need to send the data of sheet 1 in each file into another excel file. What should I do in this case?