Dear Paul Schreiner,
Here find the attachment,
I have a problem I want to copy data base on the Person name which i
highlighted with yellow colour.
suppose if the person name "JKM" a sheet will created with the name "JKM"
and the entire rows data relating to Jkm WILL copy to the new sheets of
JKM.
Your error seems to indicate that you're trying to create a sheet and change
the name to one that already exists.
without seeing a sample of your file and macros, it will be difficult to
determine what is going on. Paul-
“Do all the good you can,
By all the
