lookup in worksheet_change event

R

rumkus

Hi All

Worksheet1 contains below columns ( price list )
Company season price

Worksheet 2 contains sales
Company season amount price cost

Company and season are picked from another list.
What I want is ( if possible ) when I put amount price is picked from
sheet1 and multiply with amount for cost.

I know this too much but how can I put such formulas in
worksheet_change event.
Can you direct me to such postings.

Thank you in advance
 
Top