Hi,

I have a workbook with 31 worksheets (one for each day of the month).

A B C D E
1 # ON OFF AIR ORIGINAL
2 1 9am 10am 3 BRAZIL
3 2 10a 11am 1 COMPANY ABC
4 3 11a 12pm 2 CALIFORNIA
5 4 12pm 1pm 1 COMPANY EFG
6 5
7 6
8 7
9 8
10 9
11 10
12 11
13

On each day, I have a list to up13 different events which are coded according with the kind of sales. Column D (1=local, 2=national and 3=international)
I need to create a list of sales coded 1 only with company names (Data on column E) for the entire month on another worksheet called M&G in the same workbook. Right now I'm doing this manually.

It's possible to to generate this list automatically?

Thanks for the help