Not quite like that. I am think of a duplicate worksheet that mirrors
the content of the original (that your macro sorts), but instead of
listing the numerical data, it would list the header data from row one
- the species names. If the numerical and categorical data become
interspersed they become difficult to manipulate. Keeping them on
separate worksheets would be best.
--
guillemot
------------------------------------------------------------------------
guillemot's Profile:
http://www.excelforum.com/member.php...o&userid=29833
View this thread:
http://www.excelforum.com/showthread...hreadid=495747