There's a great feature in pivot tables called "Show All Sheets" that will
create a new sheet for every unique name in Column A. That might be a nice,
quick way to do it.

"Grd" wrote in message
...
Hi,

I'm trying to automate this - the problem is the list of names varies

Can anyone help guide me

Thanks
Suzanne