You'll have to use VBA code for that I believe. The VBA code would probably
utilize the autofilter steps that Dave & I presented.

"Thrain" wrote:


thanks for the replies. Unfortunately I cannot manually sort and paste.
Rather, I need to write a function that auto-fills the worksheet.


--
Thrain
------------------------------------------------------------------------
Thrain's Profile: http://www.excelforum.com/member.php...o&userid=29192
View this thread: http://www.excelforum.com/showthread...hreadid=490246