create a list from 2 sheets
 

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

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

I wish I could speak a good english...
Thanks for reply.

I know how to filter sheet1 ad sheet2 separately.

My need is to copy both filtered data in sheet3.

Of course i'm in need of much more studyiing...


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