Transfer data from one excel file to another excel file

Solved/Closed
llewallen - Oct 15, 2019 at 11:49 AM
saurabh2033 Posts 13 Registration date Tuesday August 25, 2020 Status Member Last seen October 6, 2020 - Sep 18, 2020 at 02:39 AM
Is it possible to transfer specific data using a formula from a single worksheet in an excel file to another worksheet in a second excel file?
Related:

2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Sep 17, 2020 at 11:28 AM
Hi Ilewallen,

Formula looks like this:
='Path[Filename]SheetName'!Cell

For example:
='C:\Documents\[MyExcelFile.xls]Sheet1'!A1

Or type an = in your destination file and select the cell you want the data from in your source file and hit enter.

Best regards,
Trowa
saurabh2033 Posts 13 Registration date Tuesday August 25, 2020 Status Member Last seen October 6, 2020 2
Sep 18, 2020 at 02:39 AM
Hello,
Yes it is possible to transfer data from one sheet to other by using formula or you can also use copy paste method.