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
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