Conditional Data

[ashani]

hi
I wonder if someone could help me.

In my spreadsheet - i have the following scenario

column a - Staff name
column b - number of sales
column c - number of stock
column d - on field / out of field
column e - month (when gone out of field)

on the sheet2

column a - Months (Jan - Dec)
column b - number of sales
column c - number of stock
column d - out of field

what I want is either a vba syntax or a formula to put in sheet 2 to determine each month number of stock, sales completed and how many staff were out of field. out of field staff changes every month - goes up and down so each month will be different and I want it to show exactly what was the situation in each month everytime the sheet 1 is updated.

I really hope someone caan help me on this.

thank you

 

[sijpie]

sounds like this could be done using pivot chart.

It may be helpful, and get more response, if you make an example of the sheet 1 and what it should look like on sheet 2.