Transfer data from one excel file to another excel file

Report
-
Posts
18
Registration date
Tuesday August 25, 2020
Status
Member
Last seen
September 18, 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
2656
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 17, 2020
440
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 2773 users have said thank you to us this month

Posts
18
Registration date
Tuesday August 25, 2020
Status
Member
Last seen
September 18, 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.