Sorting "State" Column onto separate worksheets in same workbook.

[kjstec]

I have a database of about 5000 entries. I would like to separate the
"State" (PA, FL, CA, NY, etc.) column onto separate worksheets in the same
workbook. There would be approximately 50 new worksheets. Is this possible
or is there a better way. I will be using Access eventually for this
database, but would like to sort this in Excel for right now.

Thanks,
Kathy

 

[Dave Peterson]

I'd start with one of these.

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

 

[reitanospa1]

I have a database of about 5000 entries. I would like to separate the
"State" (PA, FL, CA, NY, etc.) column onto separate worksheets in the same
workbook. There would be approximately 50 new worksheets. Is this possible
or is there a better way. I will be using Access eventually for this
database, but would like to sort this in Excel for right now.

Thanks,
Kathy

I would suggest NOT separating the data because you then lose the
"database" aspect of it. Remember that because data in Excel is not
relational, once it appears in a different sheet (table), it no longer
has any relationship to the other data.

It might be easiest to use Data/Filter/Autofilter so that you can hide
all but the state you wish to see at any given time (they will print
that same way). This keeps all of the data on a single worksheet (for
other types of sorting or data manipulation), but lets you control how
the data is displayed and printed.