VBA: Split data into Separate Workbooks

Hello Friends,

In this video you will learn how we can split our data into multiple workbooks. Every workbook will be saved in the given folder path. This macro can be used when you have a long list of your data and you have to make different files with specific data. Here in this example we have taken Employee wise performance data and we have to split our data for each supervisor.

Download the excel file from below given link:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

[RawInsanity]

This was exactly what i needed. i spent hours sleuthing the microsoft support pages before stumbling across this video. thank you thank you thank you!!!!

[TheMissSELane]

Hi All
Here’s how to Auto Fit column width:
Where he has typed “ColumnWidth = 15”, replace it with “AutoFit” ☺️ it just worked for me.

[bcnicholas]

You just saved me a week of work with a single click. Thanks

[techtipu]

I updated vba code based on my requirements and achieved goal successfully with your support. Thanks PK for your support.

[Johnck]

You have literally just saved me a heap of work, and reduced any chance of error! Absolutely amazing!! Thank you

[narottammanihal]

अति सुन्दर, P K Sir, मज़ा आ गया आपके VBA Code से, एक दम Magic... So Nice

[jaironaranjo]

Honestly i don't know which one of your videos is the best every time i watch any of you videos including Power Bi I said to myself "no way this one is the best". In conclusion Thank you for what you are doing you are definitely the best!

[aaravrajvlog]

You really are "THE EXPERT". HANDS DOWN!

[AmanUllah-yxkg]

Thank you bro I have split data into 237 separate files by this amazing technique.

[FalconFlyer]

I cant thank you enough, my work asked me to do this, I was clueless on how to go about it, u just saved me

[DavidGomez-leif]

This is life saver, I might need to use this for several hundreds of worksheets.

[lucasarancibia]

I came for help and I found glory haha. Thank you so much, my friend!!!

[CB-xkce]

You rock man, saved me 3 days of work. Thanks!

[alandouglas]

What an amazingly helpful video. Short code, easy to see how it works

[vijay_Excel]

Thanks alot for sharing woderful tutorials really It's a very useful have saved 3 hars in a

[sao]

Amazing video, I expected this task to take me a few hours but thanks to you it took 45 minutes. Thanks so much!

[Verum_Shashi]

Dear Friend,
Thanks for sharing this. You are saving tons of time for people

[JordanJens]

Excellent work and thank you for such a clear line by line explanation!

[bharathipuduru]

Hi, It is very helpful for my reports, thanks a lot for providing such a great tool, it is saving my lot of time.

[abhishekthakur]

Search finished at this point sir
Thanks a lot