Hi all,

I am working on a spreadsheet application for the water industry that predicts the cost of various types of infrastructure works. The spreadsheet is quite simple to use but it performs a lot of calculations. Each user may want to create a report of their own project and the results they want in their report will probably vary from user to user. The spreadsheet actually has lots and lots of results and graphs and so to make it easy to create custom reports I want to have a 'Create Custom Reports' worksheet. This will basically be a lot of check boxes with which people will select what results/graphs/etc they want to include in the report.

My question is (before I create this worksheet): what is the best way to do this? I was thinking of having the report created in Excel but I thought a better approach would be to have Excel export the required information to Word, where it can be edited and printed like a normal document.

So, I am not asking for advice on how to create this worksheet. The help I need is on whether to have the report in Excel or Word. Which is the best/easiest one to use? If I use Word I will obviously have to export the selected data from Excel into Word. Is this easy? Would it require some VBA programming?

Thanks in advance.
-Rob