Hi,

Die_Another_Day

Thanks for the feedback.

I was thinking of going the filter / copy route but thought that with
the number of rows involved it would probably be inefficient especially
as the filter would have to be applied / removed approx 140 times.
Additionally it would mean creating a list of unique criteria and
looping through them. However it is a 'one-off' exercise, so maybe.

The above aside there must be a more elegant solution.

If you get time to consider the problem later l would be very grateful.

Regards

Michael Beckinsale