Not possible without a whole pile of custom written VBA code. Unless you are
a familiar with writing VBA then the pivot table would be your best bet.
--
HTH...

Jim Thomlinson


"PA_Mom" wrote:

Is it possible to split data from a single worksheet into mutliple pages
without using a pivot table based on the entries in a single column. For
example, if column A lists state names and the worksheet is sorted by column
A, I would like a new tab to be created including only those items in the
worksheet for each corresponding state. Alabama data copied on a tab named
"Alabama", Arizona data on another tab named "Arizona", etc.

Ultimately I am looking to have each new tab saved as it's own workbook so I
can e-mail only the information that is applicable to the person I am sending
it to based on the state name...so if it is possible to do this automatically
(a new workbook for each state) I would prefer to learn how to do this.

Thanks!