Excellent! Man, that would have taken forever!

OK, another layer of complexity. Is it possible to do that type of sort
and still have the sorted values tied to the column headers that are in
row 1 so that I can see the names of the species in order of abundance?


Perhaps if it repeated the sort on an additional worksheet I could pull
the two sheets into my access database and link them.

Thanks again,
Jeff


--
guillemot
------------------------------------------------------------------------
guillemot's Profile: http://www.excelforum.com/member.php...o&userid=29833
View this thread: http://www.excelforum.com/showthread...hreadid=495747