Excel 2007 : Moving data from one table to another

[hossains]

I’ve 2 tables in two separate worksheets. In table 01, column A and B contain price and quantity of units purchased, and C and D contain price and quantity of units sold. I want to move data from table 01 to table 02 (which is in another worksheet), if prices and units of sold and purchased are the same. In such case, matched data will not appear in table 01, rather will appear in table 02. For example:

Price (A)- Units(B)- Price(C)- Units(D)
50- 2- 50- 2
55- 2- 43- 1
57- 4- 42- 3

Since A2 and B2 matches exactly with C2 and D2, I want to move the entire data (A2:D2) to a blank row in another table, say table 02; and table 01 will not show these data. However, if value of B2 is 3 instead of 2, I want the table like this:

Table 01
Price (A)- Units(B)- Price(C)- Units(D)
50- 1- 43- 1
55- 2- 42- 3
57- 4

Table 02
Price (A)- Units(B)- Price(C)- Units(D)
50- 2- 50- 2