Hi Jim

If you only have to use the separate sheets ones a week/month you can also create
the sheets when you need them with a macro.

See
http://www.rondebruin.nl/copy5.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message oups.com...
Hello world!

Using Excel 2002 I am trying to create a workbook that contains a
master worksheet of information. One column contains a sales person
name (there are only ten sales persons). I would like to have separate
worksheets within the workbook for each sales person and have them
automatically populated with the corresponding rows entered into the
master worksheet.

In other words, if I enter a row of data into the master worksheet and
the sales person column equals "Bob", then I would like that row of
data copied to the next available row in the "Bob" worksheet. Or, if
the sales person column equals "Tom", then I would like that row of
data copied to the "Tom" worksheet.

Additionally, it would be nice if the solution allowed for sorting of
the individual sales person worksheets without breaking the automatic
copy functionality.

Thanks to anyone who can help with this!!!

Jim