"AA2e72E" wrote in message ...
Here is a solution using SQL <snip

I think the OP wants a new worksheet for each distinct 'name'. This
would involve a curosr to loop through the distinct names and create
each sheet, so for a change I'd say a SQL solution wouldn't be the
best.

--