Excel 2007 : Creat worksheets and name them from a range of cells

**furiousfox** · 07-07-2009, 04:04 AM

Hi All
I have a range cells (A1:A20) each have a word inside.

How can I create a macro to generate/populate 20 worksheets that the names taken from the cells?

Thanks in advance for your help

Amit

P.S
This one doesn't help http://www.excelforum.com/excel-work...heet-name.html

**DonkeyOte** · 07-07-2009, 06:12 AM

If we assume you're saying Sheet1!A1:A20 contains 20 words, you want to create a sheet for each word naming the sheet per the word ...

Please Login or Register  to view this content.

**Jbentley** · 07-07-2009, 06:27 AM

Give this a go..

Please Login or Register  to view this content.

Should work fine - I added six new sheets using this.

Beware !!! It's likely to crash if one of the sheet names is already used..

**furiousfox** · 07-07-2009, 07:30 AM

Hi DonkeyOte & Jbentley

Thanks so much for the fast replay!!

I have tested both scripts, and they works great

Thanks for your help

FuriousFox

**JBeaucaire** · 07-07-2009, 07:45 AM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)