Where there's a will...there's a way...

[Nanaia]

I'm still getting familiar with the intricacies of Excel and believe there's a way to do this, but I'm not sure how...

I'm working off a spreadsheet that lists multiple order numbers and their associated sheet lengths for that order number. I want to have cell on a separate sheet that auto populates the sheet length in one cell, then list the order numbers that use that length and how many sheets each order number needs. I want it to pick one sheet size, populate the cell with the first sheet size that has a total, then list the order numbers and the number of sheets the order numbers need, then the next cell pick the next sheet size that has a total and list the order numbers that need that sheet size and how many each order number needs.
I have a table #1 on the main worksheet that has all the sheet sizes so it's available as a reference if needed. I'm working off a table #2 lists multiple order numbers (column F) and the number of sheets needed (column H) and the sheet size (column I). Print outs for tables 1 and 2 go to one area, the creation I'm working on now will have to go to another area with each sheet size on its own print. I'm arranging them in the worksheet to print on their own page, I just need help figuring out how to create the formula to get the information.

I figured I'd need to use the SUMIFS syntax but I'm not sure how.
And I just saw that the 78" row vanished so I'll be fixing that too.

TABLE #1 FLAT SHEET LINE
SHEET TOTAL	S4 SHEET
0	96	x 48
0	90	x 48
134	84	x 48
50	72	x 48
0	66	x 48
184	TOTAL SHT
1,238.00	Linear Ft.

<tbody>
</tbody><colgroup><col><col><col></colgroup>

Below is table #2

SEQ#	# PARTS	# SHEETS	S4 SHEET
1032	400	67	84	x 48
1033	400	67	84	x 48
1034	150	13	78	x 48
1035	150	13	78	x 48
1036	800	50	72	x 48

<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>

Example of end result;

Sheet size 84"

Total sheets 134

Order 1029 needs 67 sheets
order 1030 needs 67 sheets


than for the next grouping:
Sheet size 72"

Total sheets 50

order 1031 needs 50 sheets

Thank you for your help.

 

[Nanaia]

I changed strategy. I'm taking Table #1 and just breaking it up so each sheet size is a new sheet. What I'm left with is figuring out to list the sequence numbers that use each specific sheet size.