Multiple Sorts Off a Weekly Master?

[Lunch Lady]

My questions are all related to student and staff orders for a hot lunch.

Each month every student at my school is given a one-page calendar to they may order a lunch. Out of 100-some students, usually about 75 will return an order that may be for one day, or for every day in the upcoming month.

• There are 14 separate classes from Pre-K to eighth grade.
• The menu is the same for each day of the week:

Monday: chicken nuggets or chicken sandwich
Tuesday: soft taco, crunchy taco, or burrito
Wednesday*: hamburger, cheeseburger, grilled cheese
Thursday: barbeque sandwich
Friday: cheese or pepperoni pizza

*If a Pre-K student orders a burger it needs to ordered in a junior size with the vendor.

Once the monthly order for each student is recorded I would like to be able to do the following:
1. Print a weekly list for each teacher which lists every student receiving a hot lunch and what they ordered for each day of the week.
2. Print a daily list for the lunch server which lists the student class, name, and lunch item they ordered. Ideally this would be grouped into the three separate lunch times: Pre-K, then K-4th, then 5th-8th.
3. Total the orders for each day of the week by item so a monthly order may be placed for each vendor.
4. Print a weekly list with daily totals of orders, with the totals grouped by class type: Pre-K, K-4th, 5th-8th. At the beginning of each week fruit and vegetables are purchased, and it helps to not only know how many servings are needed that week, but how many servings each day, and then how many of those servings are for the youngest students on up.

I currently have a weekly master like this:
Column A: student or staff
Column B: numerical designation for class (1-14)
Column C: class name (PK 2, PK 3, ... Seventh, Eighth)
Column D: student or staff name
Columns E and F: two Monday choices
Columns G, H and I: three Tuesday choices
Columns J, K, and L: three Wednesday choices
Columns M: Thursday choice
Columns N and O: two Friday choices

I quickly realized that if I sort off of this master for one day, copy it to another sheet, I cannot return the master to its original format to sort a second day. Inter-dependence issue I'm guessing?

I can see if I copy Columns A-D to the five sheets following the master, and use one for each day of the week, I could sort the
sheet. Correct? How would I enter an order on the master then have it populate in the correct cell on the sheet so I only have to enter an order once?

At this point I am so tangled up in trying to handle the administrative part of this lunch business efficiently I don't know if my approach/setup is worthwhile. In addition, I have never really done any sorting, filtering, referencing, etc, in Excel, so I'm having trouble looking for help.

Any input would be greatly appreciated.

Thank you,
-- LL

 

[Tyron]

Hey Lunch Lady,

My initial suggestion is VlookUp. It may take a bit of work, but it sounds like it may be the way. Another way you could go is to Record a macro that while attached to a button would take care of what you want to do. In the event that there would be no way to unsort as you say (I haven't tried to do it yet) then you could use the macro to copy to a backup tab or something and then continously repeat the necessary tasks.

Is there a way that you could present us with a visual representation of what your sheet looks like. If you use the "go advanced" button at the bottom right of the reply you should be able to create tables representing each of your sheets. Showing us what you start with and what you would like the finished product to be would help us create the necessary steps to work on your problem. Most of us like to make sure that it works before providing help in the event that we discover bugs along the way. That is one reason why I like to try and create a copy of the workbook whenever possible. Just use pretend information.

later

Ty

 

[Smitty]

Welcome to the Board!

I don't have an immediate answer for you, but one of my neighbors is the Lunch Lady for our school district and my wife works for a university (food service run by Sodexo), so if you PM me your e-mail address I'll be happy to put you in touch with them.

 

[Tyron]

Hey Smitty,

That sounds great, but please post the solution so that we can all learn how to do it.

later

Ty

 

[Smitty]

Hey Smitty,

That sounds great, but please post the solution so that we can all learn how to do it.

later

Ty

I'll definitely do that if they have anything to provide.

 

[Lunch Lady]

Ty: I kept looking for the "go advanced" button and now that I have clicked on "reply" I see it ... heh heh ... I will post a sample once I get a chance to "pretend it up" a little. Will take me a day or two.

Forgive me for not mentioning my version (and any other violations please): 2010.

Will get back asap, thank you so much!

Smitty: thank you very much as well! Mind helping me out with how I PM you? I'm either pretty tired right now, and/or slow in general ....

Thanks again to both of you,

LL

 

[Smitty]

Smitty: thank you very much as well! Mind helping me out with how I PM you? I'm either pretty tired right now, and/or slow in general ....

Just left-click on my user name and select Private Message.

 

[Tyron]

Hey Lunch Lady,

Sure, no problem. I actually enjoy helping others when I can.

No violations have occurred. The Version numbers and visual examples just help ensure that you get a better response rate to your questions. I actually have started using 2013 quite a bit lately, but from knowing that you are using 2010 it would just mean that certain functions/formula types may not be available to you.

Welcome to the Excel Party.

later

Ty

 

[Lunch Lady]

Weekly Order Sample

<tbody>
[TD="class: xl85, width: 159, colspan: 2"]10/6-10/10[/TD]
[TD="class: xl63, width: 85"][/TD]
[TD="class: xl64, width: 64"]MON[/TD]
[TD="class: xl65, width: 64"]MON[/TD]
[TD="class: xl65, width: 64"]TUES[/TD]
[TD="class: xl65, width: 64"]TUES[/TD]
[TD="class: xl65, width: 64"]TUES[/TD]
[TD="class: xl65, width: 69"]WED[/TD]
[TD="class: xl65, width: 88"]WED[/TD]
[TD="class: xl65, width: 91"]WED[/TD]
[TD="class: xl65, width: 64"]THUR[/TD]
[TD="class: xl65, width: 64"]FRI[/TD]
[TD="class: xl66, width: 64"]FRI[/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl67"]Nuggets[/TD]
[TD="class: xl68"]Sandwich[/TD]
[TD="class: xl68"]Crunchy[/TD]
[TD="class: xl68"]Soft[/TD]
[TD="class: xl68"]Burrito[/TD]
[TD="class: xl68"]Hamburger[/TD]
[TD="class: xl68"]Cheeseburger[/TD]
[TD="class: xl68"]Grilled Cheese[/TD]
[TD="class: xl68"]BBQ-wich[/TD]
[TD="class: xl68"]Cheese[/TD]
[TD="class: xl69"]Pepperoni[/TD]

[TD="class: xl74"]TYPE[/TD]
[TD="class: xl73"]NUMBER[/TD]
[TD="class: xl72"]CLASS[/TD]
[TD="class: xl63"]NAME[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl77"]1[/TD]
[TD="class: xl70"]PK 2[/TD]
[TD="class: xl71"]Katie[/TD]
[TD="class: xl79"]1[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"]1[/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"]1[/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl78"]1[/TD]
[TD="class: xl72"]PK 2[/TD]
[TD="class: xl63"]John[/TD]
[TD="class: xl79"]1[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"]1[/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"]1[/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl78"]2[/TD]
[TD="class: xl72"]PK 3[/TD]
[TD="class: xl63"]Frankie[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"]1[/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Staff[/TD]
[TD="class: xl78"]3[/TD]
[TD="class: xl72"]PK 3-4[/TD]
[TD="class: xl63"]Hilary[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"]1[/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Staff[/TD]
[TD="class: xl78"]4[/TD]
[TD="class: xl72"]PK F[/TD]
[TD="class: xl63"]Jo Jo[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"]1[/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl78"]5[/TD]
[TD="class: xl72"]K PREP[/TD]
[TD="class: xl63"]Zoe[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"]1[/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl78"]6[/TD]
[TD="class: xl72"]KINDER[/TD]
[TD="class: xl63"]Sydney[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl78"]7[/TD]
[TD="class: xl72"]FIRST[/TD]
[TD="class: xl63"]Preston[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl78"]8[/TD]
[TD="class: xl72"]SECOND[/TD]
[TD="class: xl63"]Alyssa[/TD]
[TD="class: xl79"]1[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl78"]8[/TD]
[TD="class: xl72"]SECOND[/TD]
[TD="class: xl63"]Bingo[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl78"]9[/TD]
[TD="class: xl72"]THIRD[/TD]
[TD="class: xl63"]Harley[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"]1[/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl78"]10[/TD]
[TD="class: xl72"]FOURTH[/TD]
[TD="class: xl63"]Holden[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl78"]11[/TD]
[TD="class: xl72"]FIFTH[/TD]
[TD="class: xl63"]Bryce[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl78"]11[/TD]
[TD="class: xl72"]FIFTH[/TD]
[TD="class: xl63"]Gus[/TD]
[TD="class: xl79"]1[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Staff[/TD]
[TD="class: xl78"]12[/TD]
[TD="class: xl72"]SIXTH[/TD]
[TD="class: xl63"]Calista[/TD]
[TD="class: xl79"]1[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Student[/TD]
[TD="class: xl78"]13[/TD]
[TD="class: xl72"]SEVENTH[/TD]
[TD="class: xl63"]James[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl75"]Staff[/TD]
[TD="class: xl78"]14[/TD]
[TD="class: xl72"]EIGHTH[/TD]
[TD="class: xl63"]Cookie[/TD]
[TD="class: xl79"]1[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl80"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl83"][/TD]

[TD="class: xl86"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"]TOTALS[/TD]

[TD="class: xl84"]6[/TD]
[TD="class: xl84"]3[/TD]
[TD="class: xl84"]0[/TD]
[TD="class: xl84"]1[/TD]
[TD="class: xl84"]0[/TD]
[TD="class: xl84"]1[/TD]
[TD="class: xl84"]1[/TD]
[TD="class: xl84"]1[/TD]
[TD="class: xl84"]0[/TD]
[TD="class: xl84"]1[/TD]
[TD="class: xl84"]1[/TD]

</tbody>

*****************

<tbody>
[TD="class: xl75, colspan: 3"]TEACHER WEEKLY REFERENCE[/TD]
[TD="class: xl73, width: 64"][/TD]
[TD="class: xl74, width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 69"][/TD]
[TD="width: 88"][/TD]
[TD="width: 91"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]

[TD="class: xl78"][/TD]
[TD="class: xl78"][/TD]
[TD="class: xl78"][/TD]

[TD="class: xl79"]Dates[/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl65"]MON[/TD]
[TD="class: xl66"]MON[/TD]
[TD="class: xl66"]TUES[/TD]
[TD="class: xl66"]TUES[/TD]
[TD="class: xl66"]TUES[/TD]
[TD="class: xl66"]WED[/TD]
[TD="class: xl66"]WED[/TD]
[TD="class: xl66"]WED[/TD]
[TD="class: xl66"]THUR[/TD]
[TD="class: xl66"]FRI[/TD]
[TD="class: xl67"]FRI[/TD]

[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl68"]Nuggets[/TD]
[TD="class: xl69"]Sandwich[/TD]
[TD="class: xl69"]Crunchy[/TD]
[TD="class: xl69"]Soft[/TD]
[TD="class: xl69"]Burrito[/TD]
[TD="class: xl69"]Hamburger[/TD]
[TD="class: xl69"]Cheeseburger[/TD]
[TD="class: xl69"]Grilled Cheese[/TD]
[TD="class: xl69"]BBQ-wich[/TD]
[TD="class: xl69"]Cheese[/TD]
[TD="class: xl70"]Pepperoni[/TD]

[TD="class: xl83"]CLASS:[/TD]
[TD="class: xl83"]PK 2[/TD]
[TD="class: xl71"][/TD]

[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl81"]Katie[/TD]
[TD="class: xl80"]1[/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"]1[/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"]1[/TD]
[TD="class: xl72"][/TD]

[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl82"]John[/TD]
[TD="class: xl80"]1[/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"]1[/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"][/TD]
[TD="class: xl72"]1[/TD]

[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]

[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]

[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]
[TD="class: xl71"][/TD]

[TD="class: xl83, colspan: 5"]Would need a printable page for each class[/TD]

</tbody>

**************

<tbody>
[TD="class: xl73, colspan: 3"]DAILY LUNCH SERVER LIST[/TD]
[TD="class: xl76, width: 85"][/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"][/TD]
[TD="class: xl66, width: 64"][/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"]Date[/TD]
[TD="class: xl66"]MONDAY[/TD]
[TD="class: xl68, align: right"]6-Oct[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl65"]MON[/TD]
[TD="class: xl69"]MON[/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl70"]Nuggets[/TD]
[TD="class: xl71"]Sandwich[/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"]1st Lunch[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl72"]PK 2[/TD]
[TD="class: xl72"]Katie[/TD]
[TD="class: xl67"]X[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl72"]PK 2[/TD]
[TD="class: xl72"]John[/TD]
[TD="class: xl67"]X[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"]Staff[/TD]
[TD="class: xl72"]PK 3-4[/TD]
[TD="class: xl72"]Hilary[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"]x[/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"]Staff[/TD]
[TD="class: xl72"]PK F[/TD]
[TD="class: xl72"]Jo Jo[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"]x[/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"]2nd Lunch[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl72"]SECOND[/TD]
[TD="class: xl72"]Alyssa[/TD]
[TD="class: xl67"]x[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl72"]THIRD[/TD]
[TD="class: xl72"]Harley[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"]x[/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"]3rd Lunch[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl72"]FIFTH[/TD]
[TD="class: xl72"]Gus[/TD]
[TD="class: xl67"]x[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"][/TD]
[TD="class: xl66"]Staff[/TD]
[TD="class: xl72"]SIXTH[/TD]
[TD="class: xl72"]Calista[/TD]
[TD="class: xl67"]x[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl66"]Staff[/TD]
[TD="class: xl72"]EIGHTH[/TD]
[TD="class: xl72"]Cookie[/TD]
[TD="class: xl67"]x[/TD]
[TD="class: xl67"][/TD]
[TD="class: xl66"][/TD]

[TD="class: xl77, colspan: 4"]Also would want this to be a printable page[/TD]

</tbody>

******************

<tbody>
[TD="class: xl67, colspan: 3"]VENDOR ORDER[/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"]Mon[/TD]
[TD="class: xl66, align: right"]6-Oct[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"]Nuggets[/TD]
[TD="class: xl65, colspan: 2"]Sandwich[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: right"]6[/TD]
[TD="class: xl65, align: right"]3[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]

[TD="class: xl68, colspan: 11"]Want totals for each day by item, may or may not self-populate into monthly vendor order spreadsheet[/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"]**

	PK
	K-4th
	Staff
PK
	K-4th
	5-8th
	Staff
PK
	K-4th
	5-8th
	Staff
PK
	K-4th
	5-8th
	Staff
PK
	K-4th
	5-8th
	Staff

<tbody>
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]

[TD="class: xl66, colspan: 5"]WEEKLY SHOPPING TOTALS[/TD]

[TD="class: xl67, colspan: 6"]This is helpful when shopping each week for the fresh stuff[/TD]

[TD="class: xl65, align: right"]6-Oct[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"]2[/TD]

[TD="class: xl65"]5-8th[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]4[/TD]

[TD="class: xl65, align: right"]7-Oct[/TD]

[TD="align: right"]1[/TD]

[TD="class: xl65, align: right"]8-Oct[/TD]

[TD="align: right"]3[/TD]

[TD="class: xl65, align: right"]9-Oct[/TD]

[TD="class: xl65, align: right"]10-Oct[/TD]

[TD="align: right"]2[/TD]

</tbody>

[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]

</tbody>

 

[Lunch Lady]

May have just posted a hot mess.
Didn't copy as I expected, if this doesn't help to clarify what I'm trying to do I'll try again!
Thanks all!

--LL