You can copy and paste after you filter using Autofilter.

Select the column. Go to _D_ata, _F_ilter, Auto_F_ilter. Select the
date you want.

Then go to _E_dit, _G_o To (or use Ctrl-G), click _S_pecial, select
Visible cells onl_y_.

Ctrl-C, go to another sheet and Ctrl V.


--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=546925