Forum Discussion
Solved
Sending data between two excel files
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?
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
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
- 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?
