Split One Google Sheet into Multiple Sheets based on Column Value

Learn how to split one google sheet into multiple sheets based on column value.

#Google #Sheet #Split #Multiple #Sheets

[FunSpiritman]

Besides the clarity of your explanations and examples, you show the strategies to figure out new ways to approach a problem. You are not afraid to try a technique that doesn't work at first, allowing us to see how to think through a bad result while seeking a viable solution. Yes, keep stretching the limits for us.

[hhudsonn]

I rarely ever comment on instructional videos. But this is by far the best instructional video I have ever watched. I am familiar with some things, I know things can be done, just knowing which code to use is the hard part to figure it out. You actually described it all, and gave reasons for the code as you went along. I was able to split a 28, 000 row tab, into 287 different tabs. The only issue I found was, a Google timeout of 6 minutes per execution of the script. I looked into work arounds to add to your code, but determined it was easier for me to just run this code about 12 different times to complete the split process. Kudos. Thanks.

[blockwest]

my wife has now become very skeptical and thinks I'm having an affair because I spend so much time in my room. BUT i can´t get enough. THANK YOU (again!) for these great tutorials AND content.

[bigbrother]

I tried to get an array of results out of column values like you did in this video, but the way I did it is not as clean and simple as yours.
Thanks a lot. I always learn something from your tutorials.

[mdamirhossain]

I always follow this channels for Google Sheet stuff. Just amazing. Just a simple but effective solution. Love it.

[lehua]

You just saved me a headache from last night trying to use another formula thank you so much for this video

[tanveerhussain]

World's Best Teacher
Best Quality
Learn Easy and Understand
I Love And Like All Video

[siddharthjain]

This video was amazing. You are really bringing smart solutions to our problems. I loved this video. Looking for such content & video in future. Waiting for next video. I appericate your work.

[cheewurz]

Great Lesson! Found out the Hard Way that an Apostrophe is not the same as a Reverse Tick!!
The one thing I did see was that Column Width should be Automated!!!

[boomslaang]

Exactly what i was looking for... Thank you

[PumpUpTheDJ]

Thank you😭 Just what I was looking for and at the exact level of ease I needed.

[kasimmorathi]

I'm curious, I've tried Googling it, however how would you do this and create a new workbook instead? My use case is very similar, whereby I have three tabs: an FAQ/Introduction tab (no change/duplicate it in each workbook), a source data tab (almost exact challenge listed here), and a transformation tab (duplicate, only going to use importrange to copy down values).

Essentially, I need to create 60 different workbooks per "sales rep" versus 60 different sheets within the same workbook. Each workbook would have the same 3 tabs and only the source tab would be filtered down using the methodology outlined here. Edit: As an additional note - my company authorization does not permit me to use Google Collab, so just to preface, I can't use that solution.

[DaBayMayn]

This is amazing! Is there anyway to make something similar to this with dynamic data?

[dragon]

Awesome and is it gonna be triggered when we insert a new row in the main sheet? Thanks

[yantiratnasari]

hi, i have 600 different value that I want to split into 600 different worksheet, since 1 google workbook maximum capacity is 5M cells, I'm affraid it wont't fit. Is it possible to split it into different workbook? thanks

[engr.muhammadtufail]

Beneficial video learned a lot from this above video. This video is very useful in creating new sheets from the master sheet but I have one question how to recall newly generated sheets in more functions where we can put update data

[ConsulthinkProgrammer]

I just get some new method again from you. Thanks Sir :)

[joachimweyl]

Thank you for this well throught out instructional video. You did an amazing job of making this complex process seem approchable and atainable. is there any chance you have the code somewhere that can be copied? It would be very helpful not to have to type it all out from the screen.

[nhum]

Amazing! Thank you! I've been looking for this a loooong time ago.

[rajeverett]

Thanks this has been so helpful! I have a question: There is a data validation built into the last two columns of my sheets. Example: Choose A-C on dropdown. Is there anyway to keep the data validation from the master sheet and copy it to the rest of the sheets?