thanks for your replies.

I cannot use the VBA solution as our company policy doesn't allow it.

The other one seems way to complicated for an end user to perform.

Additional info: I post this request for one of our customers. The data
on the sheets is financial info which can't be changed or sorted


--
tdols
------------------------------------------------------------------------
tdols's Profile: http://www.excelforum.com/member.php...o&userid=31565
View this thread: http://www.excelforum.com/showthread...hreadid=512612