I have prepared a salary sheet of employees. I want to take department wise print of on separate page. It is easy to do through filter. However, I also want summary of department wise salary on last page only. How can I accomplish this?

Without knowing the data structure, no one can offer much advice.

Depending on what the data structure is, you may be able to summarize each department's data using SUMPRODUCT, a LOOKUP, an INDEX/MATCH combination, or an array formula of some kind - or any combiation of these.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]