more info would be helpful. One way to group the data for the desired date
is to use
datafilterautofilter

--
Don Guillett
SalesAid Software

"sjl" wrote in message
...
I want to search for a specific date (i have the dates in a column) then i
want to copy data from one table to another table. The second table is in
a
different order than the first table.

I would appreciated any help.
sjl