I'm not sure of a couple of items:
1. In the screen shot it shows Column E On Hand Qty (with no numbers below).
Then there is an extra row below each Job Num (35, 10, 26, etc). Are these
numbers meant to be in Col E? If so, then does col E represent the Qty on
Hand for any Job or just the "Specific item in this row" as stated in your
post?
In otherwords for Job 1, Item 1 you need 12. If you have 35 On Hand does
that leave 23 available for Job 2, Item 1?

2. What if you have sufficient Qty On Hand for all Items in Job 1 EXCEPT for
one (or more) Items? Do you hold the Job 1 Items that are currently on hand
specifically for Job 1 until the remaining Items become available, OR do you
free up all the Items and make them available for use by the next Job?

3. Is there any priority for assigning Items other than the Job number?

Just assuming that
1. the priority is the same as Job #
2. Col E represents your total inventory available for any job
3. if All items are NOT On Hand for Job 1, then All items will them be free
for use on Job 2

I have put together a worksheet that will accomplish the task, if I can
figure out
how to attach it to this reply or to email it to you.

"Bluegrass Fanatic" wrote:

I have a spreadsheet that contains material requirements for specific jobs.
Each row shows the job number, item number, quantity required for this job,
the total quantity required for all jobs and the quantity on hand for the
specific item in this row. The combination of job number and item number is
unique for each job. I need some help in generating a listing of what jobs
can be worked based on the on hand quantity in Column E.

Here is an example of the worksheet I am using.

Column A Column B Column C Column D Column E
Job Number Description Qty Req'd TTLQty Req'd On Hand Qty
Job 1 Item #1 12 24
35
Job 1 Item #3 11 11
10
Job 1 Item #6 14 26
26
Job 1 Item #4 10 10
15
Job 1 Item #9 33 49
50
Job 2 Item #6 12 26
26
Job 2 Item #9 16 49
50
Job 2 Item #7 18 18
50
Job 2 Item #2 20 20
20
Job 2 Item #1 12 24
35


I am at a loss with how to do this. Is there anyone that can help me figure
this out?

Regards,

WShelton