Simple excel ordering form

Job ID: 34724101

Budget: $30 – $250 AUD

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