convert a range of cells into individual worksheets?

[KL in OK]

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!

 

[Dave Peterson]

I'd keep the data in one worksheet.

Then use data|filter|autofilter to see the states that I want.

But if you really, really must. Keep the data in one worksheet and refresh the
states worksheets whenever you need (not while doing input--just run the macro
when you're ready).

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm