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

Report
-
Posts
13
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
2696
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 28, 2021
457
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
13
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!