Separating a master file into many workbooks

C

CAM

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
 
C

CAM

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top