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
saurabh2033 Posts 13 Registration date Tuesday August 25, 2020 Status Member Last seen October 6, 2020 - Sep 18, 2020 at 02:39 AM
Related:
- Transfer data from one excel file to another excel file
- Transfer data from one excel worksheet to another automatically - Guide
- Windows 10 iso file download 64-bit - Download - Windows
- Free fire transfer - Guide
- How to open .msi file - Guide
- Kmspico zip file download - Download - Other
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Sep 17, 2020 at 11:28 AM
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
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
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.
Yes it is possible to transfer data from one sheet to other by using formula or you can also use copy paste method.
