Automation of Tabs

[Danny54]

Good Afternoon

is it possible to automatically create tabs from text in a xls book and populate the new tab with data split by comma using the colors column?

From this master sheet containing data, I need to create unique tabs based on color. I'm thinking of pressing a button and a macro runs against column C(Colors) to create the unique tabs show in workbook 2. There would be a tab for each new color showing all rows from the master containing that color.

Workbook 1

New workbook showing contents of Red Tab

same workbook showing Blue Tab

Any help would be appreciated.


Thanks

 

[kevin9999]

Thanks for the assistance. When I originally did the ask, I was only using it for one type of input but since it worked so slick, I thought I would try to use it on the second type of input. It worked like a champ. I really appreciate your help. I did learn several things that I can use in the future.

Happy to help Danny, and thanks for the feedback