Auto populate a demand form from quanity list

KyleJackMorrison

Board Regular
Joined
Dec 3, 2013
Messages
101
Office Version
  1. 2019
Platform
  1. Windows
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
 
Last edited:

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Watch MrExcel Video

Forum statistics

Threads
1,108,950
Messages
5,525,827
Members
409,665
Latest member
Jessyi

This Week's Hot Topics

Top