How to Move Data Automatically Between Excel Files

[@KenjiExplains]

👉 Take our Data Analyst Program: www.careerprinciples.com/career-track/the-data-analyst-program

[@harish7041]

Can you slove my issue in live

[@Aamir_Updates]

KENJI HELPING ME ALOT..... THANKS KENJI... YOU ARE IN FACT GOLD MEDALIST IN EXCEL OLYMPICS...

[@willzinner8813]

thanks as always

[@KenjiExplains]

Thank you!!

[@flightforge30]

thanks Kenji..straighforward and Ive learned a lot

[@sophykeo9639]

table method is so easy & interesting

[@nevermind6282]

Thanks Kenji, Awesome tutorial as always. Could you please make one video for large CSV files data cleaning.

[@nishanth4323]

As always new learning from video's thanks 🙏🏻

[@albedoguardian875]

when Kenji post you watch and bookmark

[@davidcolson7400]

True story. I have a whole file of his videos.

[@sivareddy3745]

Hi Kenji thanks to your tricks. It is Very Useful.

[@nafihuppala]

Keep up the smile always...❤ Thanks a lot for all these knowledge sharing Sir...❤

[@camlex6310]

Really helpful technique!!

[@salmanakhtar4669]

7:15, kenji can we use xlookup for the same? Like we used it before in your previous video of xlookup

[@tere6279]

hi kenji, thanks a lot. ur explaining is crystal clear n brilliant delivered 👏👏 btw do u have any tricks to process data more than 800k rows? i had many data that have to process with many formula n sheets. but its usually run slow n not responding.. 😢

[@kemtemartchirouesylvestre]

Give me three excel files . I would like to write a project. You're really amazing. From Africa

[@anhiekim4117]

Thanks a lot for your video! I have one question, I follow your Table Trick to link data from Table Worksheet A to Worksheet B. But when I close Workshet A, the data in Worksheet B show #Ref, and sometime it doesn't update data. Please help me more on it? Thanks.

[@25363971]

Very useful 🎉

[@imadanow21]

What version of Excell software you're using in this video? thanks a lot.

[@gregasimciczorz3877]

Thank you for your video. Just quick question. Does it work also between excel files, that are synchronized on Google drive? I have some files on my PC in the Google Drive folder. And it seems that they are not updated, unless I open each file separately.

[@yehuditmahalal2070]

I love your super professional videos! thank you! which tools do you use for recording and editing?

[@aniekwenachigbo9462]

Can this work in two workbooks in different computers after sharing the document? It didn't work on my end though

[@eto5609]

Nice one.

[@motopelamohapi4152]

Kenji 🤝🏿

[@darkh0st]

Is it possible to automate this across multiple sheets to transfer to a single sheet? Background. Have a template sheet that is copied over to be used for multiple classes throughout the year.

[@leonardoamber2289]

*SEARCH*

[@leonardoamber2289]

*DONALD NATHAN SCOTT.*

[@user-sx5og1nj4i]

What formula shold we use if we want to repeat the same word multiple times but vertically

[@PavanKumar-xd3wg]

How to maintain the formatting? While replicating the data from Sheet1 to Sheet2 (Without using tables)

[@nickmaxwell6141]

Is it possible to open SPSS data in excel?

[@eddiemendez4766]

Why not use ifblank instead

[@Martins-TheAnalyst]

awesome

[@mdmahtabuddin9721]

Bro You just give me a massive data analysis Idea. Now I'm going to find - "Combine dirty Data from another multiple Excel workbooks by using Power Quarry in Pivot Table format". if you find the solution. plz let me know.

[@jeffreygan7028]

must all the linked files be in the same folder? and if i need to move the folder to another location (e.g. D:\ to E:\), will it still work?

[@Leghar]

With the formulas it should be fine. With power query you would need to change the path in the source step.

[@bobbygoud5518]

A simple copy paste works too

[@eddiemendez4766]

Have used linking data between files and then others would either rename the original file or move its location thereby breaking the link between the files

[@srikanthgali8991]

where is = data formula available is in 365excel

[@harish7041]

How to ignore empty cell while checking grater than value , and how to write code for check c2 coloum is some condition and d2 is Some function if both true we should get our condition

[@apoe5029]

chatgpt is free

[@Dimpalrajkumar]

These days I am seeing lot of ads!

[@KenjiExplains]

Hey I only add one add per video which is 1 minute long for videos ranging from 10-20 minutes I think it's a reasonable ratio. You get to watch it for free, download the file and even skip through the video if you're not interested.

[@ruzzputin]

Dimona

[@cumarcabaaye856]

🇸🇴🇸🇴👋

[@KenjiExplains]

Hello! Thanks for watching :)