Solved: Copy paste special different worksheet to Summary

[tlchan]

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.

[rbrhodes]

Hi tlchan,

Although I can't say I agree with having different layouts, I've provided for the two in your example.

[tlchan]

Hi rbrhodes,
Fantastic ! It works great what I'm looking for.

Thanks for your great helping hand.

:friends: