How to Move Data Automatically Between Excel Files

How to move Excel data between files automatically.

In this video you'll learn how to move data bewteen Excel files automatically. This includes linking the files dynamically, as well as creating tables in Excel. You'll also learn to extract only specific parts of data with the FILTER function and Excel tables. You'll even learn how to combine data from different Excel files using Power Query.

LEARN:

SOCIALS:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Linking Between Sheets
1:51​ - Linking Between Separate Files
3:38​ - Tables Trick
5:10​ - Extracting Specfic Parts of Data
8:47​ - Combining Multiple Excel Sheets

[Aamir_Updates]

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

[Kevin-ggv]

ACCESS FUNCTIONS ARE MOVED INTO EXCEL. SO COOL!!! THANKS a lot!!!

[nevermind]

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

[MrPelastus]

Thanks for this excellent video. It helped me solve an issue I was having with my excel application. One question: I have two sheets. The first is where data will be entered and some calculations done. I want to have every second row to be copied to a new row in the second sheet. How could I do this?

[tere]

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.. 😢

[flightforge]

thanks Kenji..straighforward and Ive learned a lot

[thaethae]

Thanks to you, I become confident in excel.

[nishanth]

As always new learning from video's thanks 🙏🏻

[nafihuppala]

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

[sivareddy]

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

[sophykeo]

table method is so easy & interesting

[yehuditmahalal]

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

[curious-homebody]

interesting.... is this possible with excel web by chance?

thank you for this video. youtube algorithm recommended it.

[MyAndrey]

Can we add conditions for the 2nd sheet (the one that takes info from the 1st file) and maybe also add like a T/F state for let's say male/ female managers and display only one category as well as some other filters? Also can this be done onto a server with excels shared from different areas of a company? I'm new into this and my task is to create such an app xD

[NamrataSingh-pfzn]

Hi Kenji, I need to combine only range of data from different sheet to one. With help of table trick I can get it but how to get the name of the sheet

[gregasimciczorz]

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.

[TheNikos]

Can the data be refreshed with the power query method when the initial master excel file is opened and used by other users??

[imadanow]

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

[salmanakhtar]

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

[Sylvestre]

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