ahhhhhhh, wonderful. so, the boss, who thinks i'm some
kind of Excel wizard.....HA!.....comes strolling up to my
desk today and asks me how i'm coming along with "that
thing he asked me about" last week.

that thing he's referring to: breaking up my single
worksheet into several worksheets based on what state
abbreviations (FL, AK, NY, etc) exist in the original
worksheet.

in case you're wondering.....yes i tried to figure this
out via these newsgroups last week, but with no luck. my
own thick-headedness to be sure, as it is true that
several suggestions were brought forward.

okay here is what i'm trying to accomplish:

7 columns.......A thru G

column D is the column where all of the state
abbreviations are stored. most of them are FL, but there
are always a certain number of them that are from across
the country.

i would like to take this single worksheet, and break it
up into as many worksheets as there are state
abbreviations found.

ex.....states on worksheet might be: FL, MN, and MA

well, i would want three total worksheets then......one
for each state.

and so on and so forth.

THANK YOU VERY MUCH IF YOU CAN OFFER ANY ASSISTANCE!!!!
THANK YOU VERY MUCH EVEN IF YOU CAN'T ; )