Transfer data from one excel file to another excel file [Solved/Closed]

Report
-
Posts
17
Registration date
Tuesday August 25, 2020
Status
Member
Last seen
October 6, 2020
-
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?

2 replies

Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
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
1
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 2942 users have said thank you to us this month

Posts
17
Registration date
Tuesday August 25, 2020
Status
Member
Last seen
October 6, 2020
2
Hello,
Yes it is possible to transfer data from one sheet to other by using formula or you can also use copy paste method.