I need to create a report every day. This report is based on an Excel file I receive daily. Because the amount of data in each Excel file is different, I find myself spending half my day on rearranging data in cells so my charts work right and my formulas don't explode.
I need a tool that let's me create an informative report from an Excel workbook, and do all the messy stuff for me. Does anyone know a tool like this? I played around with a product called Prism by SiSense - but it's still in beta (at least it's free). Does anyone know of a similar tool?
I usually do this with formulas in Excel itself. pivot tables are a *very* good option for creating an expanding data set. Another good option is to name your data groups and build charts/tables off of the names instead of cell ranges. For example, label range a1:a100 "Cost". The next time the report is run, you can redefine "Cost" as a1:A110. It should reduce the amount of broken links. (name cell ranges by Insert -> Name -> Define
