VBA to Split data into multiple sheets - Advance VBA Tutorial by Exceldestination 

This worked, you are the best!

Buen aporte, muchas gracias. Thank you very much.

Simply Wonderful. Thanks Much!

Very helpful. Thank you!

This is a great video & it's very useful. Can you explain how should I name the sheet name as 1 ,2,3... based on number of different values ?

Code worked 💪. Thank you 😊

Sooperbbbb Explanation 👍

Hi nice insights ; I’ve to create a snippet to write for a table of values mxn rows and columns , how to loop in thru each table and compute six points ascending of a particular column for each row values to be compared with a constant from the table

Great 💯

Nice sir

Good sir

I'm real new to VBA and really appreciate examples/tutorials that are this well done. I'm curious if you can suggest how to copy formatting from the original worksheet to worksheets that are created by the macro. Any help you can offer would be appreciated.

This is a great video and I have a need for it in a construction site inspection report for multiple sites by multiple builders in a given week. All the results go into a master sheet for a given week and I want to split it out to individual building sites. Is there anyway you can put the code in the description so I don't need to type it all over? Thanks for sharing.

Thanks a lot!!!

still working in 2021 thanks

This works fine on the data I am working on. Is there a way we can have certain or selected columns in the newly created sheets rather than having all columns? Much appreciated.

This is super helpful. Would it be possible for you to send me the code so I don't have to rewrite it all.

Dear Sir,When I click on submit button each & every time this button is also transfer to each sheet,& every time one blank new sheet along with other sheet is creat,why this is happening?

Hi, great video. I have one question regarding new sheet where data will be inserted, instead new blank sheet can we use existing sheet which is preformatted so it would be basically like template?

can anyone share the code please..?

I know this is a video from a year ago, but I am curious as to whether I can add more headers into the code. For instance I want rows 1,2, and 3 to all be in each sheet that is created. Then my data actually begins in row 4.

Please post the code so we can copy it

The sheet names are too long and so the code stops with an error. How can I limit characters in sheet name?

Error showing on Next source_row showing compile error: invalid next control variable reference

Good Video, it works. where can I get common button_click()? Also, how can I set auto refresh? For lines that are changed with updated details. will this be updated on same line or new line when copied to Destination

How to write for workbooks with random user name

Great tutorial. I have written the code and tried running it, but nothing happened. Any suggestions on how to trouble shoot this? What could I be doing wrong?

How do I select the files for consolidation Manually

This is an amazing video, easy to follow. However, what can I add on mine that when I add new data at the bottom of the master sheet it would split from there without repeating the previous data. I have to do it monthly..

I'm getting an error of compile error : constant expression required. I have copied your data as it is..however it is not taking my macro under that button

Can I get codings

Sir this is great code but can u set the destination file into another location like in d:/ drive how I set the path of destination file plz tell me

Superb, finally find exactly what I want, but only the problem is there, when we updating the spreadsheet and split the data, there is same datas are repeating, so please give me solution for that.

What to add to the code if I only want to select 'some column values' and split the master sheet into multiple sheets? Thank you

Sir how can I split the data with a new workbook?

EXCEL VBA MACRO FILE SAVE AS .XLSB format /Same sheet Name /Particular Folder Hi, Please help me to auto save an excel file with this below options by using VBA Macro. 1. The workbook should save as Excel Binary format (.xlsb) 2. The file name should be the same sheet name. 3. The file should save as in particular folder. Thanks!

Hi all, I keep getting Compile error, Constant expression required. Seems to be happening where i have written col. last_row = source_sheet.Cells(source_sheet.Rows.Count, col).End(xlUp).Row Any help woud be greatly appreciated.

sir, what happens after the code has filter the data ? Does new data entered goes to the filtered destination automatically

I know this is old but can someone please help??? I wrote the exact code in the video but am getting error and debug this line but cant make it work last_row = source_sheet.Cells(source_sheet.Rows.Count, col).End(x1Up).Row Thank you

very useful video sir, But in my file header is in 5 rows, it does not pick header with all 5 rows, it picks blank rows in destination sheet.

Hi. I have an excel sheet in which data keeps on updating but the fields remain the same. How can i use this code for a generic excel sheet.

I have 15 sheets. Each sheet has more than 300 filled rows and columns between 7 to 15. Some cells value is 0 (zero) on each sheet. I want a command button on a mastersheet. My requirement is :- To hide 0 value rows and columns (1 or 2 columns as per my requirement) on each sheet. Please suggest a vba code for this. Thanks

Thank you sir... Sir I m not able to add this macro to command button... Please help me...

Getting a error *application-defined or object-defined error* pls help

can i get this code

This was a great video and awesome explanation, I just need to do one final adjustment. I am going to be updating the source sheet and will run the command button multiple times. how can I set it to where it does not duplicate the info just clears the destination sheet before it imports all the data again. I have tried the following destination_sheet.cells.clearcontents destination_sheet.rows.clearcontents destination_sheet.rows("4:2000").clearcontents I have tried these commands in different locations within the code but I I just cant figure it out. I would greatly appreciate any help. Thank You,

i got error run time error

Ca n you filter by the Date? using this code?

can you send the excel file here? or can i have the sample of the excel file? thanks

please share the code Thanks!!

Where is VBA code bro

FB link

Abe adotij km rkho