Bruce,

Thanks. This is actually just what I am doing at the moment. The
problem is every time the filter criteria is changed the whole process
has to be repeated, which is laborius as the filtered data is approx.
4000 rows * 25 cols. Any other ideas?

Bertie.


--
claytorm
------------------------------------------------------------------------
claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610
View this thread: http://www.excelforum.com/showthread...hreadid=529820