Why not just use datafilterautofilter?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Robert" wrote in message
...
Hello,
I have about 50 employee numbers in sheet1 A:A. Is there code for a macro
that can make a copy of sheet2 for each instance of employee number and
name
it with the employee number as the sheet name?

thanks in advance for any help,
Robert