Need help returning column header

[astrocow]

I am trying to compile a list of lunch orders for my company using the below format and I would like to have summary sheet that reflects who ordered what for lunch on each day for easy reference.

I have a separate sheet from Monday through Saturday where I record their orders and it looks something like this:

		Chicken Noodles	Fried Rice w/ Beef	Fried Rice w/ Egg	Fried Chicken	Fried Noodles	Pizza	Lunchbox 1	Lunchbox 2	Total Price per Person
	Price	30,000	25,000	25,000	40,000	25,000	20,000	35,000	30,000
Name	Job Title
Alpha	CEO			1				1		60,000
Bravo	COO	2								60,000
Charlie	CFO								1	30,000
Delta	GM						1			20,000
Echo	Senior Manager			1				1		60,000
Foxtrot	Manager							2		70,000
Golf	Executive					1				25,000

Thus, what I want to achieve here is another summary sheet which allows to me know who's eating what on each day to allow for easier food distribution. I have no issues if any individual only orders 1 set per day but as it turns out, some are gluttons and would have 2 or more sets (could be either same or different) a day.

If I'm being unclear here, please let me know and I will clarify further.

I would really appreciate any solutions to this and I apologize for the lousy formatting of the table lol.

[Glenn Kennedy]

How do you want your results formatted?
Can you post an Excel sheet showing how you want them laid out?

[:) Sixthsense :)]

I don't see any date/day column in your data

[Glenn Kennedy]

There is one of those tables per day, I think...

[astrocow]

This is a rough example of what I'm currently working with and the plan is to use a new workbook each week.

I have a staff who goes out to buy the food ordered and I would like to make it easier for her to distribute the lunches.

Hence, I wonder if there's any way to populate the "Monday (to Saturday) Orders" sheets with the required information.

Apologies for the confusion.

[astrocow]

bumping because I still really need help for this please.

[astrocow]

Please help, i've been agonizing over this for a week already..

[Pete_UK]

You can get each individual's order for each day by putting this formula in M4 on the Monday sheet:

=IF(SUM(C4:J4)=0,"",SUBSTITUTE(IF(C4<>"",C$1&" x "&C4&", ","")&IF(D4<>"",D$1&" x "&D4&", ","")&IF(E4<>"",E$1&" x "&E4&", ","")&IF(F4<>"",F$1&" x "&F4&", ","")&IF(G4<>"",G$1&" x "&G4&", ","")&IF(H4<>"",H$1&" x "&H4&", ","")&IF(I4<>"",I$1&" x "&I4&", ","")&IF(J4<>"",J$1&" x "&J4&", ","")&"x",", x",""))

and copying down to M10. Then you can copy the block M4:M10 into cell M4 on the other daily sheets. The attached file shows this.

If you really want to have a separate orders sheet for each day, it is easy to just link the cells on the orders sheet to column A and column M on the appropriate daily sheet.

Hope this helps.

Pete

[astrocow]

I know there's no real need for a separate orders sheet each day but I'm just trying to make this whole thing as idiot-proof as possible.

I'll try the above in my actual workbook and will come back with the results.

Thanks, you're a life-saver Pete!