I have a report to generate each month that currently has to be sorted, then
copied and pasted into a separate workbook to be emailed each month after
inserting lines and headers. The report is tiered based on performance, ie
3,000, 2,500, 2,000, 1,500, and less than 1,500, with the supporting
data such as employee, social security number, etc. I would like to make this
a manual process using a macro or vba, but I am having difficulty. As I've
gotten better with Excel I've found more and more ways to automate things,
but this hasn't been one of them so far. Surely there's an automatic way. Any
help would be appreciated.

--
Message posted via http://www.officekb.com