Help sorting a data base with new sheets

This is normally done using VBA. Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.

You would edit the macro so the vCol variable is pointing to the correct column where your states are listed.



Then, you would simply run this macro any time you want to update all your individual state sheets.

Excellent, glad to hear.
As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.