Using Excel 2007 - I would liike to convert labels in a range of cells into
individual worksheets (tabs). For example, I have a list of states in my
territory in a range of cells on a single worksheet. I would like to convert
the list so that each state has its own worksheet (tab).

I have done something similar in the past, but can't remember how. I'm
wondering if it was something I was able to do with Pivot Tables.

Thanks!