Add Item Rate to the Form and Calculate Total Material Cost to the work sheet

[skhari]

Dear Experts

I have a form which help us to getting details of daily material consumption, now I have to add RATE value for each material and calculate according to the Qty or Nos.
( Private Sub Rate1_Change() ) and finally total material cost to be added in DailyConsumption Worksheet before the end line of the particular Date and Job Code

Item Rates are referred from RawMaterialList Worksheet

Kindly refer the attachments

Please help me on this task

- SK