Hi,

Im new to detailed use of Excel so I would appreciate any assistance anyone can offer.

I want to create a stock form using excel. Details of the form are-:

Job Reference No. This needs to link to a specific costing from.
List of stock: This matches the items on the stock count file
Quantity: The quantity of items (each individual item needed).

I have also added form buttons (though I dont know how to set it up :-). The yare ADD and REMOVE

What I want to do. I want to be able to input the job ref, then select the quantity of each item required. Once this is done, I want to be able to click ADD, which adds the stock items to the specific job number in the cost analysis (this is job specific). It also has to remove the items from the stock levels.

The REMOVE button needs to reverse this process.

I really hope that someone could help.

Kind regards

David