For each loop to create and name worksheets

**AlvaroSiza** · 04-28-2011, 11:19 AM

The range A2:A6 contains 5 names. I would like to loop through the names, create a worksheet, rename the worksheet the string name, and place the name in cell A1 of the newly created worksheet. Next Name. Continue process until all names have been analyzed.

Dummy worksheet attached.

Thanks!!!!!

**StephenR** · 04-28-2011, 11:23 AM

Try this:

Please Login or Register  to view this content.

**AlvaroSiza** · 04-28-2011, 11:52 AM

Originally Posted by StephenR

Try this:

Please Login or Register  to view this content.

This was perfect. Thanks! How could I modify to have it, in addition to naming the sheet and placing the same name in A1, pre-populate A2-A5 of each worksheet with a VLOOKUP referencing the array EmpNameRange? Or would a different code suffice to pull the information x number of columns out during the process you set out previously?

Revised excel attached.

**StephenR** · 04-28-2011, 11:54 AM

What information do you want to show in A2-A5?

**AlvaroSiza** · 04-28-2011, 12:09 PM

Originally Posted by StephenR

What information do you want to show in A2-A5?

The corresponding data in Columns B & C.

I added

Please Login or Register  to view this content.

After your:

Please Login or Register  to view this content.

...which works just fine. I think you have me all set for now, Stephen. Thanks for taking the time to help me. Stay well!

**StephenR** · 04-28-2011, 12:19 PM

Nice one. My pleasure.

For each loop to create and name worksheets

LinkBack

Thread Tools

Rate This Thread

Display

For each loop to create and name worksheets

Re: For each loop to create and name worksheets

Re: For each loop to create and name worksheets

Re: For each loop to create and name worksheets

Re: For each loop to create and name worksheets

Re: For each loop to create and name worksheets

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions