Help with a Macro

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

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST