creating new sheets based on specific data


Hello everyone. I need some help, and always seem to find my answers
here! I have a spread*** with a bunch of different accounts on it.
Column F contains a code which determines what group the account
belongs in. I need to split the data into separate spreadsheets based
on this code. in addition, every code will not be there everytime. How
do I write a macro to evaluate column F, and take all accounts with
certain codes and move them to a new ***. Also, how do I stop the
macro from erroring out, if one of the codes does not exist? Here is a
sample of my spread***:

A B C D E F
EN4590 TX 4/30/2004 544.1 DD MBOEAS-3
EN1155 IL 5/21/2004 503.85 ER MBOAEA-3
DT8455 IL 8/18/2003 165.44 GS MBOAEE-3
EN4590 TX 4/30/2004 544.1 WB MBOQBL-1
EN1155 IL 5/21/2004 503.85 IF MBOCA1-1

in this example, all rows would be split to their own spread***. If
there was more than one account with the same code in F, they would go
to the same spread***. I do need to hard code the various codes into
the Macro, as the spreadsheets will be saved with names relating to
those codes, so I need a way to prevent errors if a certain code does
not exist. Please help! Thank you!


--
dfeld71
------------------------------------------------------------------------
dfeld71's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21452
View this thread: http://www.excelforum.com/showthread.php?threadid=377807

.