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

Подписаться 99 тыс.

Просмотров 18 тыс.

50% 1

Download the featured file or copy the code from here: www.bluepecantraining.com/wp-...
In this Microsoft Excel video tutorial I demonstrate my VBA macro that will split data, currently held in a single worksheet, across multiple worksheets based on a column value. You can download the feature file or copy the code by visiting the page linked to above.
00:00 Introduction
00:18 See the macro in action
01:38 Walk through of the VBA macro code
06:40 Assign a button (on the Ribbon) to run the macro

Хобби

Опубликовано:

30 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 26

@KWhite-iv3se 18 дней назад

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

@kimbereleybrown9449 8 месяцев назад

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

@irfankhanuni 5 месяцев назад

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

@kleinboertjie 10 месяцев назад

Thank you, very informative

@--successingermnay2466 4 месяца назад

Very usefull and very well explained.

@mattm582 9 месяцев назад

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

@kimbui1 10 месяцев назад

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

@user-kc2lj5so5z 9 месяцев назад

THIS RULES!

@user-wh7ok8mo7t 5 месяцев назад

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

@user-wh7ok8mo7t 5 месяцев назад

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

@user-wn4xo6bm2u 7 месяцев назад

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 4 месяца назад

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?

@sarahmosaad595 10 месяцев назад

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

@ricardopedraza6101 9 месяцев назад

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

@kevj76 3 месяца назад

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

@dragonfly7022003 7 месяцев назад

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?

@JoeMcMullin 4 месяца назад

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?