Help with some functions please!

[hussnainh8]

Hi,

(Spreadsheet is attached)

"Products" sheet - I have to add a button which will automatically update the stock list for me each time I click on the button using a formula/macro. Each time I click on the button, I want to add the "Quantity to order" (Cells F10-F109) onto the "Current Stock Level" (Cells E10-E109) but this has to happen each time I click on the "Update Current Stock Level". This button is already in the sheet.

Order processing sheet - The person should be able to select the customer’s account number from a drop down list displaying the customer’s address and contact details. They should also be able to select the product’s code to display the product description and current stock level. Once the product has been displayed the clerk should be able to add the item to the customer’s purchase list and then deduct the quantity purchased from the current stock level. The order screen must make use of a range of different form controls and validation rules.

Can someone do the red part for me ^^.. Would be of great help.. I cant continue the rest of the assignment as I am stuck at this Please shed some light on this, not good with Excel :/

Thank you!

[FDibbins]

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.