Inserting rows from one sheet into the table in another sheet under certain conditions

Hello,

I have the following problem: 2 worksheets - the first one has a table of sales operations of Company X during the year, the second one has a table with production of the Company during the year. Some part of the data like product IDs are same in each sheet. I need to copy a row from the second sheet (for example: production of the product "03 001" at the date "05.07.2011") and insert it into the table in the first sheet (above the sale operation of the product "03 001" at the date "06.07.2011" or later), so that I have one table with production and sales like this:

ID Operation Name Date Quantity Price
03 001 Production Product-X 05.07.2011 15 30
03 001 Sale Product-X 06.07.2011 10 40

Maybe there are some ways to solve this problem using Macro. My English is not very good, so I'm sorry if my explanation of the problem is not clear enough.

Any ideas for this problem would be much appreciated.

Best Regards,

Vasim