Dynamically create EXECL tabs from a list of names in a column. 1

[tbtcust]

Hello All,

How can I dynamically create EXECL tabs from a list of names in a master tab from a macro?

I have a master tab with personal data. In that tab there is a column that has a list of names that repeat
- I need to get a distinct list of names from that column
- I need to take that list of names and create tabs for each using a macro

Thanks in advance for any help.

 

[SkipVought]

Hi,

"a list of names that repeat"
Make a unique list or sort the list and traverse it in a loop

Turn on your macro recorder a record adding a new sheet. Use this recorded code in your loop to create a new sheet & rename.

 

[Andrzejek]

Keep in mind there is a limit of how long - how many characters - the name of a Tab (Sheet) can be. In Excel 2010 is about 31 characters.

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[SkipVought]

...and there are characters that are illegal in tab names.

 

[tbtcust]

Thank you both. your suggestions worked just fine. This is resolved.