Auto populate a demand form from quanity list

[KyleJackMorrison]

Hello,

I have a workbook which each sheet has its own list of items for a stock check. On sheet 2 I have a form which is a company made form to request missing items.

With this I would like a code to find what items are missing from “Quantity” (Column E7:E) compared to “Quantity Held” and then populate the demand form with the items Serial Number, Name, Type and Quantity.

Here’s the catch. The demand form only has space to request 10 items at a time so, if I need to demand more than 10 items could the code move onto the second page where there is a copy of the demand form?

Location Info:

Stock 1/2/3/4/4/5/6 data starts at C7

Demand form data starts at C15 merged to O15 and goes down 10 spaces to C24:O24

Stock 1:
A------------B--------C--------------D-----E----F----G----H----I-----J-----K
Serial No. Name Brand Name Type Qty Info Info Info Info Info Qty Held

Demand Form:
C-O---------P-Q----R-----S
Serial No. Name Type Qty

Any help with this would be fantastic. I will made a mock up sheet and attach a link to give better details on what I’m trying to explain.

TIA

KJM