I have the following file:

Sheet1

February to
Style # date Revenue ($)
ABB $$
ACD $$
DED $$
DEE $$
CAA $$
FEE $$
FEH $$


Sheet2

March to
date Revenue ($)
ABB $$
DED $$
DEE $$
FEE $$
FEH $$

Each month new styles are added in sheet1. How can I get a formula to look
up a style in sheet1 and if it is new to sheet 2 add it. But only add it if
it has revenue associated with it.

Thanks,
Gingit