Listing certain cells if condition is meet

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

Thanks.

I just need to list on another worksheet the date and the name of the company which is coded 3 on column 3.

Here is a similar situation that I'm trying to solve.

This is a record for Limo trips in and out of the airport. Each trip out of the airport has a charge of $5.25 and is recorded on the sheet as code 1

TRIPS, INCOME AND EXPENSES REPORT FOR Sunday, January 01, 2012

A B C D E F

# ON OFF AIR FROM PASSENGER AMOUNT
1 900 930 3 Hyatt Hotel Mr. Jones 70.00
2 1000 1030 1 AIRPORT - DL 1469 FROM ATL Mr. John Doe III 80.00
3 1100 1130 2 Disney World Dolphin Mr. Good Looking 70.00
4 1300 1400 1 AIRPORT - AA 1400 FROM ORD Mr. Nice Guy 55.00
5 1500 1520 1 AIRPORT - UA 1755 FROM DEN Mrs. Liz Beth 66.00
6 1600 1700 3 Ritz Carlton Orlando International Airport 60.00
7
9
10
11
12
13

What I need is to automatically transfer the contents of the trip sheet above (remember I have 31, 1 for each day of the month)to a sheet that resumes and list all the trips with code 1 I do it manually and it looks like this. - The rate of 5.25 is constant.
Date Passenger Flight Rate
1/1/2012 Mr. John Doe III AIRPORT DL 1469 FROM ATL 5.25
1/1/2012 Mr. Good Looking AIRPORT AA 1400 FROM ORD 5.25
1/1/2012 Mrs. Liz Beth Linda AIRPORT UA 1755 FROM DEN 5.25


Thank you so much for your help.

Thanks. I'm new with Excel. Would love to post a real sample. How do I do it?

Thanks for the patience

Hope this will do it.

The last worksheet should list info coded 1 on columns D3:D13 for the whole month

again tks for the patience.

This may be better

I generate some data on sheet 1 and 2, which I was input manually in sheet "Meet and Greet".

Please note that only the info coded 1 on sheets 1 to 31 on column D3:D13 were listed on "Meet and Greet". These trips were originated at the airport and have a charge the 5.25 each. All other trips should be left alone.

Thanks

Thanks for your reply.

Sheets 1 to 31 refers to the days of the month. We everyday input the data as the day goes along. We need to automatically list on the last sheet "Meet and Greet" all the trips that are from the airport(coded 1) on the cells d3:d13) so we can confront our data with the data the airport provide us at the end of the month for payment. Right now every trip coded 1 is manually inserted on the "Meet and Greet" sheet.
Of course, if you have a better idea on how we could do this, please let me know. I'm sure you have a much better and vast experience than me.

Thanks again for your support.

Hello.

This could work that way too. My only concern is to how easy would be to scrow up and down to look at specific information on a certain day.

Please note that I have also a "Resume" worksheet that give the totals for each day. Is still possible to have that if we go with your recommendation?

Finally, the list that I want extract from the daily sheets is for the trips made out of the airport (which are coded (1) on column D3:D13). So let say the on the 6/1/12 I have 6 trips and on column D3 to D8 for that day I have 3, 2, 2, 1, 1, and 3, being 3 firs trip, 2 second trip and so on. I just want a list of the 2 trips on that day (coded 1 and 1 on column D) which are trips 4 and 5.

The amount of $5.25 is constant since this is the airport charge.

Thanks so much for your time.

Thanks very much.

You are right. "Resume" is what they call here summary of the month with totals itemized day by day.

I'm sure that whatever you come up with will be good. Thanks again for spending your time for me.