I think you can use advance filter .


tacarme wrote in
message ...

In a workbook I have 3 sheets.
The 1st created to archive payment orders, sorted by number and
date;
the second to archive receivable order also sorted by number and
date.

I need to put a date in A1 sheet 3 and collect all payments and cash
orders
filterd by date put in A1.

That is too far for me ..
Any help will be very appreciated .

Sorry for my english....
Dominik


--
tacarme
------------------------------------------------------------------------
tacarme's Profile:
http://www.excelforum.com/member.php...o&userid=24453
View this thread: http://www.excelforum.com/showthread...hreadid=388301