Reporting from Excel 64bit using VBA

I'm working on a project and we're coming to the part where I need to generate reports from within VBA of data in Excel workbook.

Seeing that I have very little experience in this regard; What reporting tool in your opinion is the best option for this? Should be quite easy to learn and use and MUST work on Excel 64bit. And preferably not too expensive.

(Do have some experience with Crystal Reports 8. Used it along with VB6 but on data that were in Access database.)

Hi
Depending on the structure and reporting requirements from Excel have you looked at the Pivot Table Options. In order to help further we would need to see a sample of your data and understand your reporting requirements better.
Tony

Sample of data is going to be problematic. The file is 250MB+ in size

The data that must be displayed on reports comes from all over the different worksheets. Lots of columns on each sheet with irrelevant data for some reports but relevant for others.

Seeing that I have to learn whichever way I go, I want to start with the right option. Don't want to start with one thing and then halfway in discover it's not going to work and then have to restart with something else.

Haven't worked with pivot tables but will look into it.