Simple excel ordering form -- 2

Job ID: 34724260

Budget: £30 – £80 GBP

Would like a simple excel file created to order stock.
There are 2 groups that use this excel file….. one who request
the order (green fields), and the is the one who places the
orders (blue field).
As you can see from the attached excel. there are several
products.
the person will first select the requied items in colume E
The current date will auto fill in colume F.
They can not enter any other field. once they select the
requied items, they submit and an email will be sent to the
one who orders the itmes.
The once then orders the items and enters the Qty ordered in
Coloum G
The Date ordered will automaticly fillin in coloume I
They will select submit, and an email will go back to the first
person.
They will then enter Qty received and date will auto fillin the
date received
This need to be done for each month…and we need to record
the average ordered and the amount above or belove
average….

let me know if you have any questions.
Related categories: PHP Visual Basic Data Processing Data Entry Excel