Split a Master Spreadsheet into Multiple Sheets with 1 click

Split a Master Spreadsheet into Multiple Sheets with 1 click - VBA for Beginner

Рет қаралды 236,051

6 жыл бұрын

Want to learn how to design a salary structure? Check: www.caripros.com/design-salar...
FREE template for my video: Excel for HR - Create Annual Employee Salary Increase Template from Scratch. You can download and try it out yourself here: bit.ly/2MLLdb7
FREE actual workbook for my video "Split a Master Spreadsheet into Multiple Sheets with 1 click - VBA for Beginner". You can download and try it out yourself here: bit.ly/2UmeX2v
New course Launched! I created it to show you step-by-step how to design a salary structure with regression analysis in Excel. Check out the detail here:
caripros-hr-analytics.teachab...
Topic: Split a master tab into multiple sub tabs with 1 click
Scenario: You want to split the data on a master file into multiple small sub-tabs by a chosen criteria (eg. Department, Country, etc.)
Function: Macro for Copy sheet, AutoFilter, and Loop
Workbook download:
You can download and try it out yourself here - bit.ly/2UmeX2v
I do have a course to provide additional info around this VBA function in case you are interested in learning more: caripros-hr-analytics.teachab...
Related Video:
Excel Macro/VBA - Splitting a Master File goo.gl/m8CHya
Troubleshooting when your code does not work: bit.ly/35nwtat
Troubleshooting: Why my Split Macro does not work? bit.ly/313yxRJ
Save Sheets as Multiple Files with 1 click bit.ly/2OBEuTm
Save Multiple Sheets as Separate PDF Files bit.ly/316VOlr
Send or Draft Multiple Outlook Emails with Attachment bit.ly/2p3NUfv
**Macro Code SEE COMMENT FOR IMPORTANT NOTICE**
Sub SplitandFilterSheet()
'Step 1 - Name your ranges and Copy sheet
'Step 2 - Filter by Department and delete rows not applicable
'Step 3 - Loop until the end of the list
Dim Splitcode As Range
Sheets("Master").Select
Set Splitcode = Range("Splitcode")
For Each cell In Splitcode
Sheets("Master").Copy After:=Worksheets(Sheets.Count)
ActiveSheet.Name = cell.Value
With ActiveWorkbook.Sheets(cell.Value).Range("MasterData")
.AutoFilter Field:=6, Criteria1:="NOT EQUAL TO" & cell.Value, Operator:=xlFilterValues
.Offset(1, 0).SpecialCells(xlCellTypeVisible).EntireRow.Delete
End With
ActiveSheet.AutoFilter.ShowAllData
Next cell
End Sub
*****Follow-up Consulting Services*****
If you have specific question regarding your issue, you can email me at the email here goo.gl/WejijZ Note that there will be a fee of US$200 charged for solving your issue. The turnaround is within 24 hours. Any follow-up issue in 3 days will also be answered with no charge. Payment link: www.paypal.me/caripros
*****More Videos in Playlists*****
Power BI for Beginners: bit.ly/3ivKitD
Power BI for Advanced Users: bit.ly/3lE9zmO
Excel for HR goo.gl/JdeVnd
Excel for HR - Master Class goo.gl/LYfq2f
Excel Macro - Beginner goo.gl/Yae5nc
Excel Macro/VBA - Splitting a Master File goo.gl/m8CHya
Excel Macro/VBA - Auto-hide Rows or Columns bit.ly/2Mzteb5
Excel Charts Data Visualization goo.gl/2ao6BP
Excel Vlookup Function goo.gl/kP2Wpz
Excel Pivot Table Function goo.gl/rukkPs
Excel Array Function goo.gl/i4sQH8
Excel Index and Match Function goo.gl/i7VGU4
Excel Solver/Goal Seek Functions goo.gl/FTkTnj
Excel Cell Formatting Solutions goo.gl/gpa6MY
HR Analytics - Merit Matrix goo.gl/Koy7co
HR Analytics - Salary Structure goo.gl/uZBnFa
Excel Tricks goo.gl/TeqGDw
Excel Troubleshooting goo.gl/bdY5by
Fun HR Topics goo.gl/7zVg8h
For more successful stories, view at: caripros.com/index.php/success...
#ExcelforHR#HRAnalytics#Excel#HR

Пікірлер: 333

@hisjadedwolf 2 жыл бұрын

Thank you very much, this is exactly what I need for a daily report. Your walk through was super easy to follow and I appreciate you breaking down each part of the code. I'll be setting this up tomorrow for sure.

@ABEW19043 2 жыл бұрын

Should note for future users: this runs into issues if you have hidden columns. Unhide them, and then remake your data range, even if it looks like it includes them. Anyways, this was extremely helpful, and saved me a ton of time in separating cross-sectional data into panel format for regression and analysis in R. Thank you so much.

@HeenDip 4 жыл бұрын

Pretty much exactly what I'm looking for to break apart a large data set. Well done!

@capitalbee4546 4 жыл бұрын

This Script is awesome took me a week or so to truly get it working right...but once I did IT'S AWESOME

@svetievboris 3 жыл бұрын

This is the most useful VBA script I have found so far. It is exactly what I was looking for. I used macro recorder to add a few tweaks to it. I am just hoping to figure out how to make range reference be made with an inputbox and then used in the script. Thank you very much.

@DKAFE115 Жыл бұрын

It took me a bit to figure out the syntax (1 vs L) as I'm unfamiliar with VB. But it finally worked splitting 23890 rows into 13 tabs. thank you so much

@DiffyChannel 3 жыл бұрын

Thanks so much!!! It really saves time and hope to have another video with update/refresh data automatically after splitting multiples sheets.

@h2ogiraldo 4 жыл бұрын

Thank you very much!. Your explanation was throughout. I did not know anything about macros, and I was able to follow.

@Jcpowermobile 4 жыл бұрын

absolutely what I was looking for, thank you very, very much!

@dinaoom977 2 жыл бұрын

Thank you so much this worked perfectly!!! I had 14000 rows to sort through and arrange by column value.

@selenevera8834 2 жыл бұрын

Thanks, this code works for me: Sub Macro1() Dim splitcode As Range Sheets("Master).Select Set splitcode = Range("splitcode") For Each cell In splitcode Sheets("Master").Copy After:=Worksheets(Sheets.Count) ActiveSheet.Name = cell.Value With Sheets(cell.Value).Range("MasterData") .AutoFilter Field:=1, Criteria1:="" & cell.Value, Operator:=xlFilterValues .Range("A2").Select Range(Selection, Selection.End(xlDown)).Select Selection.EntireRow.Delete End With Selection.AutoFilter Next cell End Sub

@rhettbigelow6275 5 жыл бұрын

This is great! SOO much easier than any of the other methods that I've seen! Thank you!

@CariprosHRAnalytics 5 жыл бұрын

You are welcome!

@santinoYT 3 жыл бұрын

Worked great for me and saved a lot of time. Tip: Max length for SplitCode range is 31. This is a limitation in the Excel Sheet name with a max length of 31 chars. If you change the SplitCode range's value, the data in MasterData also need to change as they will not match.

@bharathbhushan471 2 жыл бұрын

Madam, subscript out of range

@tlee7028 3 жыл бұрын

Thank you very much for this step by step tutorial. It finally works for me !

@rajibhasan5559 5 жыл бұрын

Thank you so much. its really fantastic, its really save time. Pls keep share such nice and effective project. Keep it up.

@santoshgalphade971 4 жыл бұрын

First Macro & Run Successfully, thanks alot Love you 😊😊

@manmohandeol4908 3 жыл бұрын

Very informative video I need this. Thanks for sharing.

@CariprosHRAnalytics 4 жыл бұрын

You can download the workbook and try it out yourself here -> bit.ly/2UmeX2v I also have a course to provide additional info around this VBA function in case you are interested in learning more: caripros-hr-analytics.teachable.com/p/ultimate-end-to-end-course-split-a-master-data-file-into-multiple-spreadsheets-with-excel-vba

@rosegraham136 4 жыл бұрын

Thank you! I got it to work the 2nd time around :-) Do you have a video on how to add/update when you add more to the master list? Example: Adding new lines with new departments then automatically updating the subsheets. Thanks again!

@arbabmuhammadshah8901 3 жыл бұрын

@ianbob 2 жыл бұрын

Thank you so much! This saved me untold hours.

@arunparackal684 3 жыл бұрын

thanks , This is really wonderful appreciate your help on this... Great work

@chrisczz 5 жыл бұрын

OMG， this is exactly what I'm looking for, thank you for sharing

@CariprosHRAnalytics 5 жыл бұрын

My pleasure!

@capitalbee4546 4 жыл бұрын

@@CariprosHRAnalytics I keep getting an error on the line that starts with AutoFilter

@nitsiet Жыл бұрын

This worked like butter . Only change I did is I replaced "NOT EQUAL TO" with "" .

@Kisembobusiness Жыл бұрын

Thank You Very Much. This Has saved me a lot of time. God bless you.

@kelliwebb4367 3 жыл бұрын

This is amazing and saves so much time. Is there a way of splitting by department in individual tabs & then the country (using your data) for each department as a secondary action?

@arisnopriansyah 3 жыл бұрын

thank you ...you explanation very easy to understand

@spokenbysergio7149 2 жыл бұрын

For anyone that is not getting the VBA to work properly, I'm not sure if there was an amendment to the code but here: With ActiveWorkbook.Sheets(cell.Value).Range("MasterData") .AutoFilter Field:=6, Criteria1:="NOT EQUAL TO" & cell.Value, Operator:=xlFilterValues .Offset(1, 0).SpecialCells(xlCellTypeVisible).EntireRow.Delete End With change "NOT EQUAL TO" to "" and that fixed my problem.

@jinheesung 2 жыл бұрын

Thank you for the comment. it works now with your change.

@hannahtobin4512 Жыл бұрын

mine too, thanks!

@mardangga 3 жыл бұрын

Thank you very much . You save my day 👍👍

@AlexandriaPonsonby 5 жыл бұрын

Hi, I really appreciate your video's! I work with NDIS and need to split clients and houses into their own spreadsheets (for invoicing purposes). I have an idea of how to split the houses from your video, but not how to split and send the clients to their newly created houses. Please note, the houses & client codes/names that are generated from the NDIS spreadsheets are completely different to the one's on the other spreadsheets and this is also meant to be sent to a pre-made excel template at the same time. Thank for your time and help :-)

@CariprosHRAnalytics 5 жыл бұрын

Glad that I can help!

@k_tuyenniie109 3 жыл бұрын

Thank you for sharing this! Is there a way to segregate the master sheet into existing spreadsheet instead of creating a new spreadsheet?

@ozitbittner6504 2 жыл бұрын

Does this auto-update the split sheets when you make changes to the master? Or do we have to re-run this if we make changes to the master data set? Also, if we do have to re-run it, will it make new tabs or update the ones it already made?

@vivekvibhakar7385 4 жыл бұрын

Hi, THis works great. Thank you. There is 1 issue I face, if the values in table Splitcode is more than 30 char, macro won't work. Can you help... Thanks.

@CiCiBabbee 7 ай бұрын

Great Video!!

@jyotiloomba464 4 жыл бұрын

Thanks a lot for your video, I have one query if we want grand total of coloumns also for each sheet separately ?

@user-de4rs3uj6z 10 ай бұрын

This was very helpful! Thank you!! I do not have very much experience with Macros, but is there a way to adjust the code so that the separated sub tabs could become their own workbooks (individual files) so they would not be on the same spreadsheet?

@amylee8774 2 жыл бұрын

Hi - This is great! How would I make the mulitple copied sheets paste special values, so when I come to split them later they don't have external links?

@angelicalatorreaguirre9418 6 ай бұрын

Thank you so much for sharing.

@phanikumar8898 4 жыл бұрын

Thanks a lot

@jimdreisbach6608 3 жыл бұрын

If I have each department updating information in their specific sub tabs , does this information update the master sheet with the new data and vise versa.

@yacinemessal5042 2 жыл бұрын

more than thank you for your efforts

@subhomay7 2 жыл бұрын

Excellent demonstration. I have a question regarding the same procedure. What if, I have a file which shows product and product code on the same column . For example: A032, B012 ( where "A" is the product, "A032" is the code). How to classify products ("A") into workbooks and then the corresponding product codes ("A032") as sheets will be created in the same workbook ("A")???? Would be really glad if you could help to sort it out.

@alecjg790 4 жыл бұрын

Hi, May you help? When I run the macro, the data is not being showing up on the splits. How do I fix that?

@monicardoso724 2 жыл бұрын

💖💖💖💖💖 thank you!

@alicemorili1330 2 жыл бұрын

Great video

@FMJeeping 3 жыл бұрын

Is there a way to have this code not overwrite the previous data and add onto the next available line? In otherwords. Be able to refresh and update several times a day if someone else modifies the data ?

@tradespreneur 4 жыл бұрын

Are the sheets connecting directly to the master sheet? I mean, if there is a new data in master, the split sheets also add a new one?

@meiyinong6196 3 жыл бұрын

My splitcode data is number which in text format. I copy your code and it only split into different tab without any data (only the header). I’m not sure where goes wrong. Are you able to advice?

@idhamrahadian09 Жыл бұрын

WORKSSS, thanks

@jacosmenter 4 жыл бұрын

Please assist, why does my Macro get stuck at the .Autofilter section with Runtime error424 object required?

@johnyouseph4038 4 жыл бұрын

Thanks a lot. It awesome

@CariprosHRAnalytics 4 жыл бұрын

Most welcome 😊

@aghemant 4 жыл бұрын

while processing the code it is working fine for the first value in the criteria range however from 2nd value onwards it shows the error "delete method of range class failed" . how to fix

@vathanarama 3 жыл бұрын

Hi, what if I have a master list from a google sheet which is updated daily. Can i use the same method to sort the data?

@adrienneramirez3558 Жыл бұрын

Have a great day. Thank you very much for this very helpful topics. However when i used this macro to split where the criteria used/reference is main sub number (eg 3100/0200) I encountered an error. How to fix this problem .

@rominamoens8864 5 жыл бұрын

I need to do the same thing but my sheets have a different format then the master. Is that possible?

@dipalipatil5448 6 жыл бұрын

hi , I want macros for if there is n number of data in one sheet and I want to assign that data to 10 different people in same number. how does it work.and after divide it need to go automailer on mail id with that data sheet attachment

@dfodrable 5 жыл бұрын

Hi... Can you help me? When i run the macros... It showed pop up said "Compile Error: Variable not defined". And the word "cell" on this command ("For Each cell in xxx") highlited... How to fix it... Thank you...

@tommycarreon781 4 жыл бұрын

How can you create a master sheet with different values and variables from different sheets? I have many headers but I need to mmake a mtd summary master sheet?

@asifazad6625 Жыл бұрын

Thanks for this informative video. My column values include special characters and space. When I tried to use your VBA, it resulted in errors. Please could you advise on this how to resolve such errors?

@carlosdossman3574 2 жыл бұрын

Had somebody have a - Run Time error'9' Subscript out of range-?. Debugging shows - With ActiveWorkbook.Sheets(cell.Value).Range("MasterData") - as the error line as if VBA do not recognize where the range is. Any solution available? Thanks!

@djamelbek7506 Жыл бұрын

Thank you

@sanchiarademeyer9532 Жыл бұрын

Hi, Are you able to do this if the mastersheet is a different workbook? I need to do exactly what is shown in the video, but I have to do it for multiple headings. But want each heading to form it's own workbook of sheets. Ex, I want my mastersheet, then a different book for Department, another book for Employee Name and another book for performance rating. I only want to update the mastersheet, but the different people needing the info for their area, only gets access to their workbook, and only I manage the mastersheet. Also, if I update the mastersheet, does it automatically update the other sheets? Thanks

@loriewalsh2077 2 жыл бұрын

I'm try to sort by date (field 3) is that maybe the issue? I get runtime 9 and 1004, name already used, the macro starts by make a new tab with the correct name but then does not filter for the correct date... not sure what I ma doing wrong. I have even named my worksheets the same as the video and set things up almost exactly the same but still does not work.

@karomsab 2 жыл бұрын

How do you use the same macro but include an IF statement. If the split code is included in masterlist to continue the loop and create subtabs, if not included in masterlist skip? For example: If splitcode is 1 2 3 4 5 But masterlist only includes 2,3. With the current code, it will create subtabs for all splitcodes. But I want it to only include what’s available in the masterlist without updating my splitcode values.

@snottmonkey 3 жыл бұрын

Hey - does this not work on excel for Mac? I'm getting the separate sheets but they don't seem to be filtered as per my column values.

@nitinc2373 5 жыл бұрын

Its very very nice & very useful.In the above video suppose I dont want the column C,D,E & G.I want data Like Column A,Column B,Column F & Column H then what should I do? After this suppose I want Employee Name as a sheet Name & other Column are in that sheet as a header then what to do? Please help me out.

@k.k.sabariraj6484 2 жыл бұрын

hi thks for Publishing working perfectly max how many rows data it will split??

@robertoalekohl 3 жыл бұрын

This is working for me - but it does not have each sheet separated by filter view as it is supposed to. Do you know what the problem/solution may be? Thanks!!

@fathygauthier7230 6 ай бұрын

Hello! I've followed your steps, and it was easy to understand. One question I had though: every time I tried to run it, it tells me that name is already taken, to try a different one. When debugging, it's the ActiveSheet.Name = cell.Value, any recommendations? Thank you!

@rajenthiranraj5044 3 жыл бұрын

This work well but can I use this for different data without any error which will refresh all tabs with new data.

@krimaskitchen1403 3 жыл бұрын

Thank you very much for this step by step tutorial, I have one question, what if I have filter based on Date ? I'm trying to use your script but "ActiveSheet.Name = cell.Value" gives me Run time error 1004 even I change date format to DD-MM-YYYY. Anyone have any idea on that ?

@liarcheckmate Жыл бұрын

Having same issue. On PC, there's plenty of fixes that seem easy, but on Mac, no luck.

@user-xg8gk3yx4m Жыл бұрын

What is you add values to the master. Is there a way that it will update the other tabs?

@misecretariacom 5 жыл бұрын

hello! can you paste the whole code? this is exactly what I need and I don't have any idea about how to do this, sorry, I have google sheets, can you make this in google sheets?

@narendrapatidar7363 2 жыл бұрын

i am just looking for the same macros ...thank you

@neelgugale4198 4 жыл бұрын

can you tell me how to do this is google spreadsheets also Instead of seperating the data, i want to create tabs on the number of spreadsheets that I have in a particular coloum

@AlabdaliMohammed 4 жыл бұрын

what about if i need multi criteria (eg. Department & country) ?

@sasibide2601 8 ай бұрын

Hello, I thought your video was great, easy to follow and I have used it a few times now. However, I recently noticed that the size of the file increases massively when using this macro. To the point that my laptop runs out of memory space to run it .For example, I have tried with a sample... originals file size is +4,000kb, when using the macro it becomes over 320,000Kb and that's without the macro running complete course as it crashes. One of the worksheets, when using the macro the size has become +18,000 kb however, if I was to copy paste manually, same data is only +500kb... so there is something in the macro that is adding cells, clipboard background data or something that is making the macro to be unusable for me. Any ideas of how to fix this or what the issue might be?

@keshavkalra6977 3 жыл бұрын

my spreadsheet is showing debug for overlapping for below code , can you pls help .Offset(1, 0).SpecialCells(xlCellTypeVisible).EntireRow.Delete

@nickisylvester6359 4 жыл бұрын

Can you help? I get a error at the ".Offset (1,0)...... step. Not sure how to correct this.

@taylamiller123456789 Жыл бұрын

This is great code and a great video! everytime i use this it doesn't delete the fields that are not meant to be in there, It just copying the whole master sheet to every new tab, can anybody help - thank you

@dearmysister 6 жыл бұрын

棒!

@abeadriano 3 жыл бұрын

Thank you for sharing. if the split data is being / needs to be updated by multiple user how will you sync the update to the master spreadsheet?

@CariprosHRAnalytics 3 жыл бұрын

Hi very good question. In reality I've seen a few options to deal with it. Firstly, if all users can access and edit the file at the same time, then they can make all the essential changes, save it and then run the macro on the latest version; secondly, if sharing the file access is not an option (eg, you split into multiple files and send to different users, they fill in the info and send back to you), this way, the best solution is to create another macro to consolidate all the files back into one master file. Thirdly, if the above 2 scenarios do not apply and you still want to restrict input for your multiple users, then typically you protect the sheets in a way that only one user can edit at any given time. These are the 3 common solutions that I've seen.

@ninakadu3531 4 жыл бұрын

Thanks for the video. Its very helpful and explained very properly. How can I rename worksheet if my excel worksheet name in the master file is more than 30 alphabets. Can we use LEFT Function in some way to extract on starting few alphabets only ? I have alternately used vlookup and defined a new column with work sheet names as required.. pls help

@ninakadu3531 4 жыл бұрын

I resolved the issue using Left function.. Further wanted to know how can I create individual pivot table in each individual sheet created.. pls help

@sebastianromero7454 3 жыл бұрын

Thank you so much. I have spent 3 days looking for this solution. This is amazing. I would like to know if i keep filling rows in my master tab, will the subtabs update automatically? again, thx alot!

@CariprosHRAnalytics 2 жыл бұрын

hi you will need to rename your "masterdata" range to have the sub tabs updated accordingly if you are to use the same vba code. If you want it to update truly "automatically" you would need to write additional VBA codes to do that.

@julianaellis9605 2 жыл бұрын

@@CariprosHRAnalytics ( If you want it to update truly "automatically" you would need to write additional VBA codes to do that.) can you please tell me what the additional code is for updating the sub tabs automatically from the master sheet?

@deepakbhanushali1 4 жыл бұрын

you have used this command sheets("master").copy after:=worksheets(sheets.count) but I do not want to copy blank cells into new sheet ( I know you are deleting rows using criteria in 2nd sheet but still if I have 50000 row mention in row A and I have in puted data only up till 300 in row b to row m so that macro work little but faster

@yallamrajugnaneswaravarma3139 2 жыл бұрын

How to delete entire row in one column order numbers is there in that order numbers we need to if start with 2,3 and 4 series how to delete would please help me

@aadityaarya2161 3 жыл бұрын

I have 3 questions 1) how do I make it to work in Google sheets 2) is it live formula, if a new department is added will it automatically create another tab or if we add new data in a row will it be automatically posted to that department tab 3) if we want to leave out a column say c from your master data how do we do that.

@nurtaib6749 2 жыл бұрын

HI! does anybody tried it and the filter doesn't work? it keeps all the data . I have been trying to solve it for literally hours :(

@aprilbuenaventura7479 4 жыл бұрын

Hi, great macro, thanks for sharing. I do have another macro I could not figure out, do uou mind sharing the code to split a sheet into different tabs per row of max. 130 row? So for every 130 rows I need a new sheet. And eventually save each sheet to a new file. Thank you!

@tasheenkara2892 3 жыл бұрын

the 130 isnt a max for the row, its the subcommand for subtotal. just think of it as a command and not a number. put it in and you'll be fine

@varunmonteiro5036 4 жыл бұрын

I've followed it step by step but when I run it I get an error "Invalid Outside Procedure" and its highighting the "Master" text. My master sheet has some blank columns, do you think that could affect this macro?

@rosegraham136 4 жыл бұрын

Hi! I just had this same problem. You need to make sure the tab at the bottom of the main sheet is title "Master". Right click on the tab and rename it.

@alessiaboland6304 3 жыл бұрын

EXTREMELY IMPORTANT QUESTION: so i don't have the drop down option/the arrow that you click on at 1.12 when you discuss sorting by certain criteria... it simply doesn't show up on my spreadsheet? is there a way that i can fix that?????????????????????????

@twfeuser 2 жыл бұрын

Hello, I am having an issue with the autofilter field line. It's giving me run time error 1004. I am not sure how to fix it.

@kyleblank9001 6 жыл бұрын

Hi, It was a very clear video - thank you! I am running into a challenge: "compile error: invalid outside procedure" and then it highlights "Master" -- do you know what I am doing wrong? Thanks!

@srinivaskumar8146 5 жыл бұрын

i am facing the error while run the macro " Run time error '9': Subscript out of range." please tell me how to fix it.

@konqueror07 4 жыл бұрын

Awesome tip .Thanks a lot. Just one variation I need the data to be saved in separate excel files in the same folder instead of separate sheets. Is that possible?

@CariprosHRAnalytics 4 жыл бұрын

yes totally, I have another video on saving files into folder hopefully helpful to you. kzfaq.info/get/bejne/bLNgiK2i2brYkXU.html if this is not exactly what you need, you may need to change the code slightly to fit your custom need.

@bcpguy 2 жыл бұрын

@@CariprosHRAnalytics Unable to access the video link, I think it is set to private. :(

@pawjeppesen-ifttttricks605 4 жыл бұрын

I can make It create all the rigt sheets, but I won't delete all the rows not needed. I get a "runtime error 1004" application-defined or object-defined error. what to do?

@Chatrunner1967 5 жыл бұрын

This is really awesome, but I have the issue that the sheets that are created show different format which makes it that these sheets are close to useless. Also, I have buttons on the "Master sheet" One of them gives the option to open the userform where data needs to be entered. Is there a sollution for these problems? Please post a video from it if possible..

@eslamahmed-wh5qv 2 жыл бұрын

many thanks but when I use it, the copy is made but delete no

@christinec1670 2 жыл бұрын

When you fist pump into the air after it works!!! Yippie!! thank you for this!! So so helpful!!!

@sriramlimaye 3 жыл бұрын

getting runtime error 424 at auto filter level where asked to filter based on colum 2 which is division

@muslimnasyroh516 4 жыл бұрын

Error. Run-Time error 1004 Application-defined or object-defined error. How could I fix this? Please help me.

@abfandn7939 3 жыл бұрын

Yes i am getting it too

@brommel16 3 жыл бұрын

Everything works but the filtered items don’t delete in the new sheets, any fix?

@shaharyarmalik7151 4 жыл бұрын

error With ActiveWorkbook.Sheets(cell.Value).Range("MasterData") the next sheet just copied the master file..

@vamseekrishna321 4 жыл бұрын

Any solution??

@shaharyarmalik7151 4 жыл бұрын

@@vamseekrishna321 surfed another video

@lokisdailydiaryoforbs2133 4 жыл бұрын

How did you fix? When I use that code it splits everything by the tab, but doesn't delete out the categories (of other tab names) that I no longer need on each tab... it is still including all of the information, but there are multiple copies of tabs with different names now.