Hello people,
here is my problem:

Suppose i have two worksheets (FIRST, SECOND) with 5 columns each (col. A is
for COLOR1 and col. B is for COLOR2)
FIRST worksheet will have about 1000 records. In SECOND worksheet I want to
have only records which has either in col. A or col. B (for example) the word
'RED'
Is that possible for EXCEL? And if I enter a new record in FIRST worksheet
which has the word RED will it be added to SECOND worksheet?

I hope my problem is clear, if not I will repeat it, thanks everyone