On Jan 15, 2:46 pm, kjstec wrote:
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.