tlchan
07-12-2009, 04:54 PM
Hi three,
I am prepare the daily report on each sales staff of different job function. However I would like to consolidate the month total for each individual staff under 1 summary sheet ("MTD"). There is also 1 product in common (credit card) for all staff.
How should I summarise the month total from row 36 of each staff to sheet("MTD") each month eg Jul-09 to June-10 using copy paste special append to last row of summary report in for each month per staff?
Attached the file for reference.
I am prepare the daily report on each sales staff of different job function. However I would like to consolidate the month total for each individual staff under 1 summary sheet ("MTD"). There is also 1 product in common (credit card) for all staff.
How should I summarise the month total from row 36 of each staff to sheet("MTD") each month eg Jul-09 to June-10 using copy paste special append to last row of summary report in for each month per staff?
Attached the file for reference.