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