VBA Macro: Split Excel Worksheet into Multiple Worksheets Based on Column Value

Рет қаралды 26,942

Chester Tugwell

Күн бұрын

Пікірлер: 37

@KWhite-iv3se 6 ай бұрын

Truly Amazing! Very helpful, this was exactly what I was looking for. You saved the day for me.

@rachitmittal1131 4 ай бұрын

Thank you so much for this. Saved so much time

@kimbereleybrown9449 Жыл бұрын

Hi Chester. Great video and explanation of the code. Thank you.

@sarahmosaad595 Жыл бұрын

Is there a way to modify your VBA code so it works for blank cells as well?

@mattm582 Жыл бұрын

Great video. I was also wondering if there was a way to update the code to include blank cells.

@cosorioandino 3 ай бұрын

Have you find how to do it?

@cosorioandino 3 ай бұрын

Have you find a way to include blank cells?

@kimbui1 Жыл бұрын

Hi Chester, loved the video. Is there a way to modify your VBA code so it works for blank cells as well?

@irfankhanuni 11 ай бұрын

Hi chester, loved this video , it worked for me , thanks

@stefapaco 8 ай бұрын

Did all the steps but for me it only creates a new sheet but doesnt populate it with anything

@kevj76 8 ай бұрын

Great video, unfortunately when i run the macro, it copies the headers across for the first new worksheet but then does not populate any data in the rows below and I have no other sheets created

@JoeMcMullin 10 ай бұрын

Absolutely love this script, one issue. When I run it as a macro, it runs perfect. When I add the macro to a button on the ribbon it runs and only creates one new tab/worksheet with only two rows of data (should be many more) but the script just stops. Not sure why there would be a difference. I am using Office RibbonX Editor to create my own menu group and have no issues with other scripts. Thoughts or anyone experience this problem?

@--successingermnay2466 9 ай бұрын

Very usefull and very well explained.

@tomgraham4534 4 ай бұрын

great tool and explanation although macro doesn't copy all of my requested data - only some of the rows and some of the columns, missing critical data - any clues how to fix?

@maureenmorrissey-n9o 11 ай бұрын

This is great Chester. How can I modify this macro to keep the formulas on each new sheet created?

@SteveBeatson Жыл бұрын

Really useful video. The column I want to split the data by is a date field, which the macro doesn't recognise unless I remove the date formatting. I then need to convert the data in each tab back to a date. Is there anyway to have the macro recognise dates? Thank you.

@alexandralerebours4770 9 ай бұрын

Hi Chester, It's awesome. Works great! Do you have a vba macro code that allows to send each of the worksheets to email address that would be located in a column of that worksheet?

@maureenmorrissey-n9o 11 ай бұрын

This is great Chester. Is there a way to modify this macro to retain the formulas on each tab?

@dragonfly7022003 Жыл бұрын

I am new to VBA Macro, but is there a way to do everything you have on the macro, but sort by the first two or three chars in a cell row? For Example Cell A-000, sort by just the A- in the cell?

@eddynoboa1059 4 ай бұрын

Hello Chester, I did use your code and it worked using very small data and thanks for that. In the other hand, with big data have 24 columns and lots of data when I used your code only picked up 13 columns and based on the column value to pick up on (had 120 unique accounts) it only picked up around 5 or 6. How can I pick all unique accounts with the 24 columns??

@tomgraham4534 4 ай бұрын

i have this very same issue - have you fixed this?

@gamingindia8251 Жыл бұрын

Is there any way in which column copy past even if there are blank cells?

@NilishaKothari 4 ай бұрын

It didn’t work for me. I have bigdata and have to split into around 80 sheets. Any idea how?

@shahzadsaleem3384 11 ай бұрын

Sir I can not see my split data option in my macro please help me

@kleinboertjie Жыл бұрын

Thank you, very informative

@sangambhavsar5663 6 ай бұрын

Hi Chester. I am unable to do so in my worksheet. this code is not working. should i sent my data to you?

@GaryHassay-n1d Жыл бұрын

THIS RULES!

@ricardopedraza6101 Жыл бұрын

Hey Chester, amazing coding, how to add a total in column "E" ?

@boyyobpp Ай бұрын

It's not doing all my data only a portion

@jjfi214 9 ай бұрын

Subscribe! Take you for all you do

@jodileathatsme 11 күн бұрын

Did not work for me, unfortunately. I had high hopes, but it just creates a new sheet with nothing on it and a second sheet with headings and one row of data. Tried it several times to no avail. DARN! This is the second VBA macro video I've watched and neither worked, which is unfortunate and disappointing.