Posted: Fri Nov 30, 2007 8:40 pm Post subject: What is the best way to generate custom reports from Excel
I have data in an application that I can export to .csv. Each day the data changes, and I need to run a report on each day's data.
The situation isn't exactly this, but this is the best analogy that I can create (the real situation is difficult to explain): the data reflects the statistics of a helpdesk. I want to generate reports on how many tickets were opened by date, how many were closed by date, how many possess a status of "x", how many have status "y", etc.
Since I am taking the data from Excel, I am currently just running filters and copying/pasting into a report worksheet, but this is far too manual. I want to automate the process as much as possible.
What do you all think is the best way of doing this? Pivot tables? VB app? Something else?
I don't want to use Crystal primarily because of the cost. Additionally, I would like to develop something from 'scratch' for the experience.
I can highly recommend "Pivot Table Data Crunching" by Bill Jelen (www.mrexcel.com). I currently have the version for Excel 2007, but I'm pretty sure there were previous ones too. This book takes a really good real-world view of using Excel Pivot Tables to get complex jobs done easily.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum