Separating a master file into many workbooks
 

Hello,

I have a excel file call "Master", which contains names and policy number,
insured. What I want to do is somehow create a new workbook based on the
change of a name and name the file based on the name column. For example I
may have a name "John Smith" policyNumber z3333, "Athena" for the insured.
I would copy and past the row(s) (can be 1 or 50 rows) and past it to a new
workbook and name the file "John Smith". When the name is different for
example "Linda Parks" in the "Master" I would then copy the rows and paste
it into new workbook and call the workbook "Linda Parks". This is a drag,
especially when you have to copy and past to 15 different workbooks. There
is has to be another way. Any tips or visit a website will be greatly
appreciate. Thank you in advance.

cheers

Separating a master file into many workbooks
 

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

See the workbook example

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CAM" wrote in message ...
Hello,

I have a excel file call "Master", which contains names and policy number,
insured. What I want to do is somehow create a new workbook based on the
change of a name and name the file based on the name column. For example I
may have a name "John Smith" policyNumber z3333, "Athena" for the insured.
I would copy and past the row(s) (can be 1 or 50 rows) and past it to a new
workbook and name the file "John Smith". When the name is different for
example "Linda Parks" in the "Master" I would then copy the rows and paste
it into new workbook and call the workbook "Linda Parks". This is a drag,
especially when you have to copy and past to 15 different workbooks. There
is has to be another way. Any tips or visit a website will be greatly
appreciate. Thank you in advance.

cheers

Separating a master file into many workbooks
 

Ron,

You had helped me in the past and once again I appreciate your help. I will
take at look what you suggested. Thank you.

cheers


"Ron de Bruin" wrote in message
...
Try
http://www.rondebruin.nl/copy5.htm

See the workbook example

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CAM" wrote in message
...
Hello,

I have a excel file call "Master", which contains names and policy
number, insured. What I want to do is somehow create a new workbook
based on the change of a name and name the file based on the name column.
For example I may have a name "John Smith" policyNumber z3333, "Athena"
for the insured. I would copy and past the row(s) (can be 1 or 50 rows)
and past it to a new workbook and name the file "John Smith". When the
name is different for example "Linda Parks" in the "Master" I would then
copy the rows and paste it into new workbook and call the workbook "Linda
Parks". This is a drag, especially when you have to copy and past to 15
different workbooks. There is has to be another way. Any tips or visit
a website will be greatly appreciate. Thank you in advance.

cheers