Excel 2007 : Create Paper Usage Report

As part of my company's "Go green" initiative I have been asked to create a report that shows individual page counts for people that print in the office to raise awareness. I may have found one way to do this however I am not very good with Excel.

My print server logs every print job sent to it including number of pages printed. I can export the log to a CSV file and remove the unneeded columns however the column showing total pages printed also contains other information that I do not need. I have attached an example that shows all print jobs ocurring on 3/1/11.

I am looking for a way to semi-automate the process of generating a report but I do not know how to do it. I will still have to manually export the data from my server and remove any unneeded info, but from that point is it possible to run a script or macro that will grab the data and generate a nice looking report that may possibly even include some graphs? (Graphs are optional). Idealy I want a report that shows total pages printed by user and a total page count for everybody. Can this be done?

I left the date and time columns however date and time are not important. I will be creating a monthly report so I will only export the data for the month that is needed. The only columns that are really needed are User and total pages.

This works perfectly! Thank you. Can I ask one more question? How can I change the macro so it trims off the domain name from the username? The raw data shows "APG\Username" and in the report I would like to strip off APG\ so it just shows "Username".

Thanks again! This is a huge help.

Works perfectly. Thank you again, you have been a huge help!!