Hi,

I am needing some help coming up with a Macro that can do several things.

First thing it should do is go down Column B, grab each new name in Column B , and create a new worksheet at the end and change the name of the Worksheet to the name that was grabbed in Column B. Then keep going through all the names in Column B, doing the same thing with each new name, until it reaches the end.

I am a little familiar with Excel Macros, but dont know enough to write a dynamic one such as this. Any help is greatly appreciated.