How to create different workbooks from a single worksheet
 

Hi,

I have data in a worksheet, in which the main distinguisher is the
manager name. I want to create different files for each manager.

How can this be done.

Thanks
fari

How to create different workbooks from a single worksheet
 

Could you please describe the layout of your data in more detial? e.g. Are
the Manager names "Column headings" or they are data which appear multiple
times in a particular column?

Regards,
Edwin Tam

http://www.vonixx.com


"fari" wrote:

Hi,

I have data in a worksheet, in which the main distinguisher is the
manager name. I want to create different files for each manager.

How can this be done.

Thanks
fari

How to create different workbooks from a single worksheet
 

Thanks for the response. The Manager name is a col heading and then
there are several managers in that col.

Thanks
fari

How to create different workbooks from a single worksheet
 

You may want to look at Ron de Bruin's code:
http://www.rondebruin.nl/copy5.htm

fari wrote:

Hi,

I have data in a worksheet, in which the main distinguisher is the
manager name. I want to create different files for each manager.

How can this be done.

Thanks
fari

--

Dave Peterson