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
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